Database Architect
Auxenta (Private) Limited
مجموع سنوات الخبرة :16 years, 11 أشهر
• Providing consultancy for NorthBay Solutions, an AWS partner in the US
o Guiding the offshore database team of NorthBay Solutions.
o Providing consultancy in an Oracle to Aurora PostgreSQL migration project.
o Part of a team developing a data lake solution.
o Developed a solution in Python to extract and ingest data for a real estate data warehouse.
• Managed two 2-node RAC databases running on Oracle Solaris zones and other single instance databases
• Responsible for 24x7 uptime of the databases
• Used AWR and ASH reports to identify performance issues
• Identified top SQL and tuned them
• Was involved in PL/SQL development
• Guided developers to follow best practices in PL/SQL development
• Leading the DBA team
• Providing database consultancy
• Used AWR, ASH and ADDM reports to identify performance issues
• Enhanced database performance by tuning instance parameters
• Identified top SQL and tuned them
• Enhanced the schema design
• Used Oracle Streams technology to replicate data between OLTP and reporting databases
• Setting up and monitoring backups of Oracle and SQL Server databases
• Designing schema
• Database development and performance tuning in Oracle, MySQL and SQL Server
• Working with MySQL RDS instances hosted in the Amazon cloud
• Task automation and scripting
• Deployed Oracle Audit Vault
• Installed Oracle Enterprise Manager Grid Control 11.1.0.1.0 and agents
• Managed and scheduled backups of databases using RMAN
• Set up Data Guard environments in production systems
• Installed Oracle Grid Infrastructure 11g release 2
• Installed Oracle Database on a 2 node RAC and did basic administration
• Managed backups of production databases using RMAN
• Setup Fast Start Failover using Data Guard Broker
• Migrated data from customers' existing systems to Direct FN Order Management System using Oracle SQL*Loader
• Managed space efficiently in Oracle databases by shrinking and moving segments
• Database development and performance tuning in Oracle and SQL Server environments
• Created shell scripts to automate various database related tasks
• Installed and patched Oracle database 10g and 11g in Windows and Linux environments using GUI and silent mode
• Deployed and maintained production database environments independently
• Provided 24 x 7 production database support
• Implemented SQL Server Replication to synchronize data in real-time between two load balancing production databases
• Implemented an availability solution for a production environment using SQL Server Log Shipping
• Transferred data between databases using Oracle datapump and SQL Server Integration Service
• Introduced a complete release management process for database related development
• Was responsible for test automation
• Developed applications needed to test SDK’s using .NET and Java technologies
• Developed solutions for performance tests using Visual Studio Team Test 2005
• Worked on hardware projects involving different POS architectures