Senior Database Consultant Resume

SUMMARY

Experienced Senior DBA production consultant with extensive knowledge in Oracle EBS Applications DBA (12.2 & 12.1), SQL Server(2016,2014,2012,2008) & Oracle(12c,11g). Expert in HADR solutions, Migration, Upgrades & Performance tuning on Self hosted, AWS & Azure platforms.
Having more than 21 years of Senior Production DBA experience in ORACLE/SQL Server/Oracle APPS/Oracle EBS platforms
Over 5 years of Experience as Oracle Applications DBA/Oracle EBS DBA
Over 15 years of Experience as Microsoft SQL Server DBA
Over 6 years of Experience as Oracle DBA
Expert in data migration (From SQL to Oracle & Oracle to SQL on self - hosting as well as on AWS)
Expert in HA (High Availability)/DR(Disaster Recovery) based
Certified in Oracle 12c Database Administration
Microsoft Certified Solution Associate (MCSA) for SQL Server 2016 DBA Administration

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Consultant

Responsibilities:

Mentoring Junior & Offshore DBA’s on maintaining SQL Server 2014/2016 instances & Oracle 12c databases on AWS EC2
Assist other DBA’s in solving critical issues.
Performance tuning using ADDM & AWR reports

Confidential

Senior Database Administrator

Responsibilities:

Assisted in migrating their existing SQL 2012/2008 environment to SQL 2016 SP1.
Troubleshooting issues with Transactional/Snapshot replication.
Installing & configuring SSRS servers for their reporting purposes
Installing & configuring SQL 2016 ALWAYSON Availability groups as well as SQL 2016 clustering for their requirements.

Confidential

Senior Database Administrator/Database Administrator

Responsibilities:

Senior DBA for SaaS Software Company hosting a multi-terabyte environment (more than 6TB) as part of Travel expense management in a hosting platform.
Upgraded and Administered Oracle Applications (12.1 & 12.2)
Performed Cloning on Test/Dev environments using Production environment
Administer concurrent manager & reports and setup profiles for user & system.
ONLINE Patching (ADOP) EBS environments, database patches, Weblogic patches as well as applied application related TAXWARE patches
Maintaining Oracle applications using ADADMIN, AUTOPATCH, ADCONTROLLER, AUTO CONFIG, RAPID CLONE, AD RELINK, AD SPLICER etc.
Configured RMAN for Oracle database backups
Established Documentation best practices on severity issues, Upgrading, patching & cloning with respect to Oracle Applications/SQL Server platforms
Possesses good working knowledge on various clustering platform, which includes Microsoft windows clustering using Microsoft Hyperv3/Hyperv2 & ESXi based solutions.
Focused heavily on automating daily tasks using Powershell
Configuring/maintaining SQL 2012 ALWAYSON instances for critical databases
Lead DBA Person for Disaster Recovery site based in Dallas, TX. Designed DR process model with Systems & Storage team and is instrumental in keeping DR site up-to-date.
Did 2008R2-> 2012 migration for 200+ sql instances (on VMWARE/ESXi platform) with more than 3000 databases on it about 2 and half years back.
Comfortable with Sql Server replication even though we used replication on hardware storage layer for our DR site. Also familiar with Logshipping & Database mirroring concepts.
Expert in troubleshooting issues using SQL Profiler, monitoring tools & DMV’s.
Upgraded Hosting Platforms from SQL 2000 to 2005/2008 R2 apart from installing SP’s & Critical Updates (CU’s)
Extensive working knowledge on mapping LUNS for various SAN storages (NETAPP, EMC, NIMBLE) with respect to SQL Server Clustering platform.
Migrated SQL Server data onto Oracle 8i platform and maintained those oracle databases till 2007.
Daily responsibilities include standard production DBA duties, Query optimization, troubleshooting issues, automating regular tasks, monitoring systems overall health using monitoring tools, working on customer tickets & document changes adhering to change management process.
Key player for Evaluating & deploying new SQL instances in hosting side.
Experience in Normalization, Database design, Performance Analysis, partitioning and Production Support for very large (VLDB) and Complex Databases.
Key person in setting up local office in Bangalore, India and implemented in house datacenter
Experience with datacenter work such as moving fiber cables on brocade switches & server setups.
Migrated data between Oracle & SQL Server platforms using Oracle Migration Workbench & MS DTS.

Confidential

Oracle/SQL Server DBA

Responsibilities:

Responsible for maintaining about 9 Oracle database servers for Abbott Laboratories when their DBA was not available from Dec 2000 till Feb 2001.
Responsible for maintaining hosting database servers for Captura Software before joining them in Permanent position
Selected as Employee of the Quarter for successfully migrating data from Oracle 8i to SQL Server 2000.
Designed and implemented Backup & recovery strategies using RMAN for Oracle 8i.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship