SUMMARY

• Database Administrator with 17+ years of experience leading database design, development, migrations and upgrade teams working with SCM and Oracle Databases 9i/10g/11gR2/12c (RAC) in development, test, UAT and production environments.
• Experience in Oracle/MYSQL/MSSQL Server/DB2 LUW design, patching, cloning, upgrade, performance tuning, migration and implementing standards and best practices.
• Experience with Oracle RAC, ASM, RMAN, Dataguard, while implementing solutions following the Agile Methodology, participating in design and code reviews.
• Experience in Golden Gate 12c installation, configuration, troubleshooting replication issues. Experience in leading and handling DBA team as well as multiple projects simultaneously and good exposure to Database Management and Release Management. Coordinating various project related activities involving project Planning, Execution and Risk Management in tune with the core business objectives.
• Familiar with AWS services like S3, EC2, RDS (DynamoDB, MySQL, Redshift), VPC. Also, Familiar with Azure implementation for Golden gate.

PROFESSIONAL EXPERIENCE

Confidential, Troy, MI

Lead Oracle Golden Gate DBA

Responsibilities:

• Lead a team of 24x7x365 Database admin, in the Data Solutions group.
• Implemented Golden Gate 12./12./12.3 across Boeing for migration of data across platforms in Teradata, MS Sql server, AWS, Azure, Postgres
• Monitored the implementation of Goldengate, managed databases using OEM 13c.
• Implemented Goldengate Micro services Architecture for multiple clients, maintained the extracts and replicats, troubleshooted them
• Wrote monitoring scripts for Golden gate, general maintenance scripts for daily automation tasks.
• Troubleshooting, Performance Tuning Golden Gate issues
• Working on shell scripts, developing them
• General DBA activities, support Postgres, MSSQL server 2016
• Provided L3 level of support, Designed and maintained databases in Oracle 12c
• Part of Community meetings, change management meetings
• Also, working on Postgressql 9.6.7 on the Linux servers as DBA maintaining databases for applications, used PgAdmin 4 and installing pgClient
• Monitoring databases using OEM 13c
• Performing daily DBA activities, helping the team troubleshoot issues in ASM, patching, RAC
• All oracle databases on Aix 7.1

Confidential, Roswell, GA

ORACLE DBA SME

Responsibilities:

• This was a short project and the client wanted someone to fill a production DBA role.
• Actively involved in GG troubleshooting
• Involved in Deploying production related code in PL/SQL and executing sql scripts for application teams in AK/NH/ND regions
• Troubleshooting user issues, resolving Service Center tickets on time
• Administering Oracle 10g/11gr2 databases
• Providing Support 24/7 in an production environment
• Working on shell scripts, database migrations, and OEM 13c.
• Worked with Oracle Identity Manager (OID)11g in integrating it with Oracle Internet directory, registering new and old databases, access to the databases, and LDAP account management

Confidential, MI

Lead Oracle DBA - Consultant

Responsibilities:

• Administered multiple 11gr2 and 12c databases as part of a team completing a complete DB migration, of 300-400 DBs, with over 50 TBs in memory, from NY to MI, setting up Active Dataguard and configuring Dataguard broker in 12c.
• Followed DB Availability Disaster Recovery standards to ensure DB performance and availability, working with Dataguard.
• Used Shell Scripts to configure Dataguard, to monitor space and backups.
• Replicated DBs to ensure availability to ensure DB protection across the network, ensuring standby DBs were properly working.
• Created shell scripts to add tablespaces automatically when needed to databases.
• Installed and configured Golden Gate 12c and configured uni-directional replication.
• Resolved and troubleshoot issues in Golden Gate replication and worked with Oracle support, when needed.
• Migrated databases using GG and RMAN for 2 node RAC and implemented and configured GG in 2-node RAC cluster.
• Handled Supply Chain /Clinical databases for Confidential and administered them via OEM 13c.
• Configured RMAN Backups of all databases and created user accounts following company’s standards
• Analyzed performance issues in the application and troubleshoot them using SQLT and TKPROF.
• Executed processes for evaluation of system space, database allocation and storage metrics.
• Supported a 24x7x365 environment with on-call responsibilities, actively participating in problem resolution management.
• Patched Oracle DB environments and cloned database, completed upgrades and implemented backup and monitoring procedures.
• Worked with ServiceNow tickets, change requests and resolved them as per the defined SLA.
• Worked with Oracle Identity Manager (OIM)11g in integrating it with Oracle Internet directory, registering new and old databases, access to the databases, user provisioning, resources assignment and LDAP account management
• Also maintained Peoplesoft databases and applications with OIM
• All oracle databases on Aix 7.1

Confidential

Sr. Oracle DBA

Responsibilities:

• Part of the team in charge of process improvement of ITIL and handled DBA projects in Oracle 11gr2, 12c and DB2 9.7 to 10.5, MSSQL Server 2005/2008.
• Managed OEM installation plan and managed OEM for 40 servers and 200 databases.
• Managed MSSQL Server 2005/2008 databases and completed regular backups via scheduler and ensured Availability Disaster Recovery plans were met, by transferring backup copies from one server to another.
• Managed quarter wise patching of Oracle/SQL Server databases/Db2 Databases
• Actively part of WOMBAT(DR) testing of Oracle/Db2 databases.
• Partitioned tables, RAC, completed performance tuning and worked closely with the Database and SOX Compliance team to ensure and implement SOX standards and controls across the organization.
• Actively represented all the changes in the CAB
• Installed and configured GG 12c and configured replication between primary and target servers using bi-directional replication and troubleshoot replication issues.
• Configured Dataguard brokers, installed and configured active Dataguard for 12c databases.
• Supported a 24x7x365 environment with on-call responsibilities; actively participating in problem resolution management and working with ServiceNow for change requests, tickets as per the SLA defined.
• Provided Level 3 support on production issues
• Partitioned tables, RAC and completed performance tuning of Oracle Databases.
• Defined database standards, administered databases for KP nationwide, working with different IT application and support groups.
• Executed queries in TOAD 9.5, completed database design and modeling while working with different Application Teams in order to gather and implement Logical and Physical Design.
• Used different modeling Tools such as Erwin and TOAD, for ERD generation.
• Coordinated production deployments with IBM and ensured successful implementations.
• Planned and upgraded 11.2.0.3 to 11.2.0.4/12.1.0.2 with latest PSU patch for all databases.
• Installed and configured OEM 12c agents.
• Provided successful performance recommendations to improved database performance and ensured 99.95% availability targets.
• Developed UNIX shell and SQL scripts for database monitoring.
• Approved production schema changes, database design and control migration of Oracle schema objects, nodes and implemented Oracle failover technology.
• Configure and implement non-prod and prod Active Dataguard in 11gr2 and 12c.
• All oracle databases on Aix 7.1

Confidential

Oracle DBA, Project Lead

Responsibilities:

• Administered and troubleshoot Oracle RAC in CRS, node sync issues and SCAN issues on two-node implementation in Oracle 11gR2 using OEM and adhere to PCI security standards.
• Tested OLTP transactions, SQL response time, and database workload during peak hours, and generated AWR reports for any database related issues.
• Responded and resolved incident tickets, and provided timely updates.
• Maintained Oracle software (upgrades, patches etc.) and fine tune Oracle instance components and cron jobs for SQL and PL/SQL.
• Developed UNIX shell and SQL scripts for database monitoring.
• Lead production deployments every week with the SCM Team for all 140 applications including Planning and managing the releases for critical apps like Pyramid, BFM and Accurate.
• Setup auto-deployment environments for legacy applications, documented high-level system environments, service catalogues, etc
• Working on partitioning of tables, RAC, performance tuning of Oracle Databases.
• Locally managed tablespaces were used which track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.
• Approve production schema change, database design and control migration of Oracle schema objects, nodes and implement Oracle failover technology - Dataguard.
• Design and implement a backup & recovery using RMAN and data modeling and Oracle database design.
• Create Standby databases to maintain consistency over the data during Disaster on Production site.
• Manage the database size of more than 1.3 TB.
• Provided training to DBA Team on Oracle 10gRAC in IMS Practice and involve in RFP and POC activities.
• All oracle databases on Aix 6.1

Confidential

Technical Lead - Oracle DBA

Responsibilities:

• Managed databases for multiple Customers in DB2(9.7), MySQL(5.5) and Oracle 10gR2/11gR2 and 11g on multiple projects.
• Work closely with project leads (PM, BA and QA), product managers and developers to deliver quality software to deadlines, Participate proactively in all stages of System Analysis, Design, Development, Code Review and Implementation. Single handedly designed and implemented PL/SQL modules for security of 9i DB using DBMS OBFUSCATION packages and wrote custom algorithm in PL/SQL