Oracle
Abhilash Shah
Troy,MI
Summary
Seasoned Senior Database Administrator with expertise in database management, performance tuning, and disaster recovery planning. Known for high productivity and efficient task completion. Excels in problem-solving, teamwork, and adaptability to ensure seamless database operations and support.
Overview
23
23
years of professional experience
1
1
Certification
Work History
Sr Database Administrator
Tata Consultancy Services
Troy, MI
02.2018 - 05.2024
- Transitioned SQL Server Database from on-premises to Azure Cloud using Database Migration Assistant on VM
- Received ARC files to Azure cloud blob storage and processed the data to Azure SQL database.
- Handled Azure SQL Server Databases and provided necessary administration
- Assisted 24x7x365 database administration team within Data Solutions group
- Executed deployment of Golden Gate versions 12.1 through 21c across enterprise environments
- Deployed and maintained Goldengate on Oracle 12.2 RAC/19c RAC for PSDH application using XAG
- Provided on-call database administration for PSDH
- Handled installation of HRP systems
- Trained the application team members on the system
- Completed various database hardening projects
- Facilitated user management for both SOX and non-SOX databases
- Set up Rubrik Cloud backups for SQL Server and Oracle Databases
- Set up SQL Server 2016
- Maintained Postgres SQL on Windows environments
- Upgraded non-production and production databases from 12c to 19c with DBUA
- Set up SQL 2008 and upgraded to SQL Server 2016
- Created and optimized SQL Server databases
- Enhanced SQL server performance by tuning problematic queries
- Collected specifications for data architecture
- Took backup snapshots and restored them as necessary
- Configured GoldenGate 12c on SQL Server 2016 for database replication
- Monitored the implementation of Goldengate, managed databases using OEM 13c.
- Implemented Goldengate Microservices Architecture for various clients
- Collaborated with ORACLE Support on urgent matters
- Monitored disk space for trail files
- Upgraded GoldenGate 12.2 to 12.3
- Implemented Classic, Integrated, and Coordinated replicates.
- Mentored other members of the team in Golden Gate 12c features and worked with infrastructure and application developers directly to resolve any replication issues.
- Wrote monitoring scripts for Golden Gate, general maintenance scripts for daily automation tasks.
- Troubleshooting, Performance Tuning Golden Gate issues
- Developed Shell Scripts for cron jobs.
- Performed general DBA tasks
- Provided L2/L3 level of support, designed and maintained databases in Oracle 12c.
- Created Oracle SRS, and worked on them
- Participated in community and change management meetings
- Administered PostgreSQL 9.6.7 databases on Linux servers
- Monitoring databases using OEM 13c
- Implemented ServiceNOW for change management
- Developed and maintained database security policies to ensure data integrity, confidentiality and availability.
- Monitored system performance, identified potential bottlenecks, implemented solutions to improve efficiency.
- Implemented backup procedures for databases and monitored their success rate.
- Provided technical support for database users, troubleshooting issues as they arise.
- Created complex stored procedures and triggers to automate various tasks within the database.
- Maintained multiple versions of the same database while ensuring data consistency across them.
- Designed and implemented disaster recovery plans in case of system failure or data corruption.
- Configured high-availability systems such as replication clusters and log shipping for mission critical databases.
- Optimized existing queries to ensure maximum performance and scalability of the databases.
- Analyzed query execution plans to identify potential areas for improvement or optimization.
- Implemented change management processes to ensure smooth transition between different stages of development life cycle.
- Installed new software releases, patches and upgrades on production servers as required.
- Resolved conflicts arising from concurrent access by multiple users to shared resources.
- Developed scripts using T-SQL language to automate routine administrative tasks.
- Assisted application developers in designing efficient SQL queries for better performance.
- Trained junior DBA team members on best practices related to database administration.
- Developed and implemented security initiatives to protect important company data.
- Wrote scripts and processes for data integration and bug fixes.
- Analyzed and developed technical and functional specifications for databases.
- Partnered with project management teams on development of scope and timelines.
- Analyzed workflows and established priorities for daily operations.
- Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
- Devised reports and visualizations to present requested data in sleek format.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
Oracle DBA SME
Infinite Technologies
Roswell, GA
09.2017 - 11.2017
- Company Overview: Conduent Healthcare ORACLE DBA SME
- 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
- Followed HIPAA rules for compliance and accuracy in Revenue cycle management (RCM) process databases for claims to member providers and revenue management databases
- Implemented SOX related database objects for before and after images
- 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
- All oracle databases on Aix 7.1 and Linux 7.1
- Used Service NOW for change management, incident management
- Implemented physical database design including tablespaces, storage optimization and partitioning.
- Migrated databases from one platform to another using tools like export and import, datapump.
- Automated daily DBA tasks using shell scripting and cron jobs.
- Installed, configured and administered Oracle 10g, 11g databases on Linux, Unix platforms.
- Monitored database performance and tuned SQL statements for optimal performance.
- Developed backup strategies using RMAN to ensure data protection and recovery.
- Implemented high availability solutions such as Oracle Data Guard, Streams replication, GoldenGate.
- Configured network components such as listeners, tnsnames.
- Managed user accounts, roles and privileges in the database environment.
- Performed trouble shooting of any issues related to Oracle Database server or applications accessing it.
- Used OEM for monitoring, diagnosing and resolving problems quickly.
- Created PL and SQL procedures and functions for automating day-to-day operations of the organization's systems.
- Deployed third party applications with Oracle Databases as a back-end repository system.
- Developed scripts for automation of various DBA activities like adding disk space, reorganizing table spaces, index maintenance .
- Designed and developed ETL processes using Informatica PowerCenter for loading heterogeneous source data into target systems .
- Generated periodic reports about system performance and resource utilization trends .
- Worked closely with Application teams in identifying and fixing application related issues due to inefficient SQL queries .
- Provided technical support during project implementations by troubleshooting complex production issues .
- Involved in capacity planning activities by analyzing current usage patterns and predicting future growth trends .
- Oversaw daily operations including staff management and customer service at the SME.
- Analyzed data from surveys conducted with customers of the SME.
- Monitored trends in industry to stay ahead of competition for the SME.
Lead Oracle DBA - Consultant
Trinity Health
, MI
01.2017 - 07.2017
- Implemented physical database design including tablespaces, storage optimization and partitioning.
- Migrated databases from one platform to another using tools like export and import, datapump.
- Automated daily DBA tasks using shell scripting and cron jobs.
- Installed, configured and administered Oracle 10g, 11g databases on Linux, Unix platforms.
- Monitored database performance and tuned SQL statements for optimal performance.
- Developed backup strategies using RMAN to ensure data protection and recovery.
- Implemented high availability solutions such as Oracle Data Guard, Streams replication, GoldenGate.
- Configured network components such as listeners, tnsnames.
- Managed user accounts, roles and privileges in the database environment.
- Applied security patches to upgrade the database version or fix security vulnerabilities.
- Performed trouble shooting of any issues related to Oracle Database server or applications accessing it.
- Used OEM for monitoring, diagnosing and resolving problems quickly.
- Created PL and SQL procedures and functions for automating day-to-day operations of the organization's systems.
- Deployed third party applications with Oracle Databases as a back-end repository system.
- Developed logical and physical data models based on requirements from application teams using ERwin toolset .
- Designed and developed ETL processes using Informatica PowerCenter for loading heterogeneous source data into target systems .
- Developed scripts for automation of various DBA activities like adding disk space, reorganizing table spaces, index maintenance .
- Generated periodic reports about system performance and resource utilization trends .
- Worked closely with Application teams in identifying and fixing application related issues due to inefficient SQL queries .
- Provided technical support during project implementations by troubleshooting complex production issues .
- Involved in capacity planning activities by analyzing current usage patterns and predicting future growth trends .
- Evaluated new technologies and products related to Oracle Database Administration and implemented them when necessary .
- Created program backups and information recovery systems.
- Created and altered database storage structures to meet user needs.
- Updated and inspected database security features and protocols.
- Managed user accounts and support systems within complex Oracle database and cloud systems.
- Developed and ran autonomous database backups.
- Maintained working knowledge of programming languages and technical documentation.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Maintained knowledge of advances in information technology systems and applications.
- Wrote scripts and processes for data integration and bug fixes.
- Developed and implemented security initiatives to protect important company data.
- Partnered with project management teams on development of scope and timelines.
- Assessed data processing proposals and requirements to determine project feasibility.
- Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
- Organized meetings between stakeholders to discuss project details and timelines.
- Assisted in developing new methods for data collection and analysis techniques.
- Developed and implemented customized strategies to meet client needs.
- Provided recommendations based on quantitative data analysis regarding strategic direction.
- Identified areas for improvement, narrowing focus for decision-makers in making necessary changes.
- Analyzed key performance indicators to identify effective strategies.
- Monitored operations and reviewed records and metrics to understand company performance.
- Utilized document management system to organize company files, keeping up-to-date and easily accessible data.
Sr. Oracle DBA
Cognizant Technologies
, CO
07.2013 - 01.2017
- Managed DBA projects across Oracle 11gr2, 12c, DB2 9.7 to 10.5, and MSSQL Server 2005/2008
- Supervised OEM operations across multiple platforms
- Implemented and set up OEM 12c monitoring agents
- Maintained HIPAA compliance throughout RCM databases
- Developed database structures for capturing SOX compliance images
- Managed MSSQL Server 2005/2008 database operations
- Performed quarterly updates for Oracle, SQL Server, and Db2 databases.
- Engaged in WOMBAT(DR) testing for Oracle/Db2 databases
- Completed performance tuning and partitioned tables
- Communicated all modifications to CAB
- Installed and configured GG 12c for bi-directional replication
- Configured Data Guard brokers for high availability
- Maintained 24x7x365 environment with on-call duties
- Provided Level 3 support addressing production issues
- Partitioned tables and implemented RAC solutions
- Standardized national database protocols for KP
- Executed queries using TOAD 9.5
- Utilized modeling tools like Erwin and TOAD for generating ERDs
- Led production deployment coordination with IBM
- Upgraded database versions from 11.2.0.3 to 11.2.0.4 and 12.1.0.2
- Supplied effective performance recommendations to enhance database efficiency
- Created UNIX shell scripts for database oversight
- Authorized modifications to production schema and database design
- Configured non-prod and prod Active Data Guard in 11gr2
- Managed Oracle databases on Aix 7.1 environment
- Utilized BMC Remedy for change oversight
Oracle DBA, Project Lead (Database Services)
Syntel Inc
New York, NY
05.2001 - 06.2013
- Managed Oracle RAC in CRS addressing node synchronization and SCAN issues on a two-node implementation
- Conducted tests on OLTP transactions and analyzed SQL response times during peak hours
- Resolved incident tickets promptly
- Upgraded Oracle software components, including patches
- Crafted UNIX shell scripts for database oversight
- Led weekly production deployments with SCM Team for 140 applications
Education
MBA - Marketing
Canadian School of Management (TASMAC)
Pune, IndiaBS - Physics
MG Science Institute (Gujarat University)
IndiaSkills
Oracle Database Management SQL Server Administration Cloud Migrations (Azure, AWS) GoldenGate Implementation Active Data Guard Configuration RAC & ASM Expertise Performance Tuning & Optimization Data Integration & Replication Disaster Recovery Solutions SOX & HIPAA Compliance Shell Scripting & Automation Database Design & Development RMAN Backup & Recovery Database Upgrades & Patching Project Management Team Leadership & Mentorship OEM (Oracle Enterprise Manager) ServiceNow Change Management Data Modeling & ERD Generation PL/SQL & T-SQL Development
Certification
- Azure Administrator Associate AZ104
- Oracle 12c Administration
- Oracle 10gR2 Administration
- Project Management Professional (QAI, Bangalore)
- ITIL v2
- AWS Trained
- Mongo DB 4.0 Trained
- HVR (High Volume Replication)
- Azure Fundamentals AZ900 Certified
- Oracle 10G Database SQL Expert
- Brain Bench J2EE Professional
- Novell Certified Internet Professional
- IBM Clear Case UCM, IBM Build Forge
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimePart TimeContract WorkLocation Preference
On-SiteRemoteHybridImportant To Me
Career advancementWork-life balanceCompany CultureFlexible work hoursPersonal development programsHealthcare benefitsWork from home optionPaid time offTeam Building / Company RetreatsPaid sick leave401k matchStock Options / Equity / Profit SharingSoftware
MS SQL Server
MS Office
Azure Administrator
AWS Solution Architect
IBM Build forge
Jenkins
ITIL
Project Management
Languages
English
Native language
Hindi
Beginner
A1
Timeline
Sr Database Administrator
Tata Consultancy Services
02.2018 - 05.2024
Oracle DBA SME
Infinite Technologies
09.2017 - 11.2017
Lead Oracle DBA - Consultant
Trinity Health
01.2017 - 07.2017
Sr. Oracle DBA
Cognizant Technologies
07.2013 - 01.2017
Oracle DBA, Project Lead (Database Services)
Syntel Inc
05.2001 - 06.2013
MBA - Marketing
Canadian School of Management (TASMAC)
BS - Physics
MG Science Institute (Gujarat University)