About me

Pankaj Yadav
Sr.Database Administrator (Oracle/PostgreSQL/Sql Server)
Oracle Certified Professional
Nashville, Tennessee, USA
pankaj.mcajnp@gmail.com
https://www.linkedin.com/in/pankajdba
https://www.oracleworlds.com/about-me/

As a Senior Oracle Database Administrator, I am highly skilled and experienced professional who has dedicated my career to managing and maintaining complex database systems. With my deep understanding of Oracle database architecture, installation, configuration, and troubleshooting, I ensure that my organization's database systems are secure, reliable, and perform optimally.

Over the 13 years, I have honed my expertise in Oracle database management best practices, including data backup and recovery, database security, and performance tuning. I always up to date with the latest trends and technologies in the field, continually seeking opportunities to improve my skills and knowledge. 

My experience and technical prowess are invaluable to my organization, and I am a critical member of the IT team. I work closely with developers, business analysts, and other IT professionals to deliver solutions that meet business requirements. I am an excellent problem-solver, able to quickly identify and resolve issues, and I always ensure that database systems are properly documented and maintained. 

As a Senior Oracle Database Administrator, I am a natural team player, collaborating effectively with others to achieve shared goals. I am an excellent communicator, able to explain complex technical concepts to non-technical stakeholders. My passion for database administration and my dedication to my work inspire those around me. Beyond my technical skills, I am known for my professionalism, attention to detail, and work ethic. I am reliable and trustworthy, and I take pride in delivering high-quality work. I am always willing to go above and beyond to ensure that my organization's database systems are running smoothly. 

In summary, as a Senior Oracle Database Administrator, I am a highly skilled and dedicated professional who is essential to my organization's success. My technical expertise, problem-solving skills, teamwork, and passion for my work make me an invaluable asset to any organization that values the importance of data management and security.

Professional Summary:

13+ years of IT/Database administrator experience with excellent knowledge of managing database Infrastructure, Database configuration of Oracle 11g,12c /19c with disaster recovery, and full/Archive RMAN Backup configuration to avoid any data issue. Expertise in SQL Server 2008R2-2019 database along with data center migration. Professional and troubleshooting experience includes Oracle, RAC, Exadata Database, Azure cloud database, multi-version database Upgrade, Migration, Patching, Performance tuning, Standby DR, DB Refresh, Backup & Recoveries, database Cloning, Monitoring, configuring and managing HA Solutions, and complete Golden Gate management. Expertise in MSBI, Power-BI Report, SSRS report, SharePoint migration, Systems Analysis, Integration, Design, and development of complex OLTP/OLAP Data Warehouse and RDBMS for different domains like Bank & Finance, Mortgage, Insurance, and HealthCare.

Technical Skills:

Operating Systems: HP-UX 11.0, Solaris, IBM AIX, Red Hat Linux 4.2, 5.3,6,7, Oracle Enterprise Linux, Windows Server 2008/2012/2016 R2/2019

Databases: Oracle 9i / 10g / 11g /12c /19c Oracle Database, SQL Server 2008R2/2016/2019 MongoDB-Mongo 3.4, Studio 3T, Mongo Ops manager, MongoDB Compass, Robo 3T

Tools and Utilities: Oracle Enterprise Manager OEM 10g/12c/13c, SQL*Loader, Export/ Import, Goldengate, Expdp/Impdp, RMAN, 12c/18c/19c, Power-BI, SharePoint, Office365

Languages: Oracle, SQL, PL/SQL, Shell Scripting (KSH, Perl) Power Shell

Other Tools: DMA, RDA, SQL Loader, OBIEE, SSMS, SSIS, SSRS, Oracle Export/Import, Toad, Sql*plus, SQL Developer, OAS (Oracle Application Server 11i, R12), Oracle Grid Control, Performance Reports AWR, ASH, ADDM.

Cloud: Oracle, AWS, Azure

Certifications:

Oracle Cloud Database Migration and Integration 2021 Certified specialist

Oracle Cloud Database Services 2021 Certified specialist

Oracle Cloud Infrastructure Certified Associate

Oracle Certified Professional 12c Database Administration

Oracle Certified Associate 10g Database Administration

SAFe®4 Certified Scrum Master

MongoDB Trained from MongoDB University

About Expertise:

13+ years of experience in IT career as an Oracle Database, SQL Server RDBMS, and MongoDB NoSQL Database administrator, Exadata, RAC, Golden Gate Administration,12c/19c CDB/PDB, SQL Server to Oracle and HDFS Golden Gate replication, Standby, Data Guard, Unix/Linux, MS SQL Server 2008R2/2016/2019.

Experience to coordinate geographically separated, offshore/onshore and nearshore teams to manage operations.

Experience in Troubleshooting & Problem-solving in the critical situation including a quicker resolution of Performance.

Participate in design architecting and managing various applications and databases for Member Portal/Provider Portal/Shop & Enrollment/Broker and Admin portal in the healthcare domain.
Excellent oral and written communication, presenting, facilitating, decision-making, and problem-solving skills to manage projects.
Experience with multitenant databases version 12c and 19c CDB and PDB’s architecture with hands-on experience.
Served as Senior Database Admin /project lead in the completion of 100+ medium- to large-scale.
Extensive knowledge of infrastructure and environment management, Change management, release management, code versioning and deployment methodologies.
Expert in configuring and managing all types of Oracle Golden Gate on 11g/12c/18c/19c database for data replication in Oracle, SQL Server, and Hadoop platform.
Expert in OGG upgrade 12c to 19c and reconfigure extract/pump and Replicate process without data loss.
Expert in OEM/OMS Patching/ discover database, onboard all types of VM and Server into OEM.
Extensive knowledge in AWS Clod computing, RDS oracle database configuration, backup and restore.
Experience in AWS IAM user management/S3 all type of storage, Archiving and VPC.
Experience analyzing and reporting data to identify issues, trends, or exceptions to drive improvement of results and find solutions.

Skilled communicator, thorough in explaining complex IT knowledge to subordinates, and management.

Experience in Data Migration using RMAN and Oracle Data Pump, Export/Import,physical standby database, Snapshot standby, and active data guard.
Database Administrator proficient at supporting Oracle installations which require real-time data replication using Golden Gate Transaction Data Management Tool.

Expert to configure golden gate initial and incremental data replication in multiple environments, prepare Golden Gate parameter files for initial load, Extraction, Pump, and Replication.

Manage and monitor the database performance and system performance as per business need
Extensive knowledge in MS SQL Server 2012/2014/2016/2017 with Business Intelligence SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
Extensive knowledge in managing SSIS/SSRS/SSAS MS Business Intelligence Services to manage business requirements and provide Systematic reports to analyze the business need

Experties in Service-nowIncident/Service request management, Change management, and central monitoring and Report configuration and Service-now Dashboard.

SQL Server database complete full/differential/log backup setup through dba tools/ ola-Hallengren, point-in-time recoveries of SQL Databases through automated backups.

Professional Experience:

UBS Financial Service – Nashville TN July 2022 – Till Date

Sr. Database Administrator (Oracle Database/PostgreSQL)

Support 1200+ instances and multi-environment server up to 500 TB Critical finance Databases with Oracle, SQL Server, and PostgreSQL databases.

Manage backup and restore required schema/tables from Production to UAT/DEV Environment for testing and report as per business need

Works in database troubleshooting and maintenance activities and solves all types of Golden Gate issues such as abended, lagging, long transaction issues multiple types of OGG Error handling and management in SQL Server and Oracle databases

Configure database with standby database for DR activity and switchover and convert db into a snapshot

Configure data guard DGMGRL to maintain and perform replication and switchover activity

Expertise to upgrade oracle database 12 to 19c along with CDB and PDBs and golden gate

Create and manage database user accounts and grant roles as per requirement

Works with Oracle Database Vault to provide powerful security controls to help protect application data from unauthorized access

Deployed and Restored database from RMAN including Point in time Recovery

Coordinating with the database engineering team to fix and install required database patches and implementation

Provide extensive support to resolve the database performance issues, database capacity issues, data replication with OGG, and Stand by data guard features

Provide support to customers by working through the request/issue ticketing system

Configure and create ServiceNow report/Dashboard to monitor backlog incidents and tasks and work with the global team to resolve the issues

Work with Oracle Support to raise SR and resolve the critical issue with 24/7 rotational shift

Working on-call rotation to support database/application continuity

Manage databases for day-to-day activities like user management, database management, backup/recovery, Golden gate extract/pump/replicate configuration, convert the database to snapshot for DR

Contributing to the development of process improvements and best practices. Proactively lead, coach, and motivate project team members

Performing OMS/OEM releases and patches to resolve vulnerability issues

Configure and onboard servers and databases to monitor OEM and perform automotive activities

Provides on-call support as per the schedule and handles the escalation and issues for oracle and Postgres

Objects on Net Inc. (Insurance House) – Chicago, IL July 2020 – July 2022

Sr. Database Administrator (Oracle Database/ SQL Server)

Support 70+ database Servers and multi-environment instances up to 60 TB Databases

Installed and configured Golden Gate 11g/12c/19c version on SQL Server 2014/2016 and oracle 11g/12c database for data replication

Implement database switchover from Production to Standby and vice versa as per patch requirement

and application performance requirement

Applications systems administration tasks like creating, and managing users’ privileges and responsibilities

Managing all types of Goldengate configuration and replication in multiple environments including EXADATA database 12c/18c

Works in database troubleshooting and maintenance activities and solve all type of Golden Gate issues such as abended, lagging, long transaction issues multiple types of OGG Error handling and management

Setup database users and assign appropriate roles and privileges

Implement 11g/12c database switchover through data guard broker and stander switchover method

Proficient in MongoDB No-SQL database management, MongoDB Database management through Studio3T Tools, managing MongoDB Backup/Recovery/Performance through Mongo OpsManager

Experience with Mongodb database backup and recovery configuration and management

Experience in handling MongoDB admin access to manage all the database user privilege roles and responsibilities

Cognizant Technology Solutions – Discover Financial Services, Riverwoods, IL Feb 2016 – March 2019

Sr. Oracle Database Administrator / Onsite Lead

Support 1000+ instances and multi-environment servers up to 30 TB Databases

This project deals with developing multiple applications like Student Loans, Card Bank transactions, and reporting with various mechanisms such as Backup and restore, DB Clustering, Log Shipping, DB Mirroring, Replication, HADR, and job monitoring to promote the high availability of system, etc

Managing and coordinating with the offshore team to fulfill the business requirements and completed tasks/changes on production/non-production databases as per client-requested deadlines

Worked and Expertise in Oracle RAC, Exadata, Oracle Performance & Tuning, SQL Tuning, and Instance Tuning

Worked on OEM 13c configuration and management with alert and reporting

Worked on Production Support, attending production calls, troubleshooting the application, and resolving bugs

Manage all kinds of Security/Version / One off and bug fix patching on RAC and Non-RAC databases

Identifying and troubleshooting long-running queries, locked sessions to improve overall performance, Setup database users, and assigning appropriate roles and privileges

Worked on cloning the database through RMAN backup.

Configure the service now dashboard to present all types of reporting (Daily/weekly/Monthly) incidents, change requests, and service-now request threshold

Implement, Maintain, and Troubleshooting High Availability Architecture (DR Planning and Solution)

Coordinate with infrastructure teams like Network, Compute, and Storage for delivery of functional database clusters

24/7 Support for critical production database with Oracle RMAN 10g/11g/12c RAC / Exadata server

Objects On Net Inc. Atlanta, GA March 2015 – Aug 2015

Sr. Database Admin

Support production, development, and test databases at high availability

Administration of Oracle Databases 10g/11g

Applying patches related to performance and bugs on Test, Dev, Stage & Production instances

Experience in Installation, Configuration & re-configuration of Oracle for Large databases on Unix O.S, Solaris, Linux, HP, VMware, and Windows, etc.

Applications systems administration tasks like creating, and managing users and their responsibilities, configuration of Standby Databases for High Availability

Database User Management, Privileges, Roles, Auditing, Profiling, Authentication Cloning Oracle Database and Applications using Rapidclone

Storage management, sizing the database objects, monitoring file systems, and tablespace growth Setup, and maintaining a physical standby database for high availability

Wipro Ltd. Pune May 2014 – Jan 2015

Senior Database Administrator

AWC Software Pvt Ltd. Noida April 2013 – April 2014

Database Administrator

NH Infomedia Ltd Delhi March 2012 – April 2013

UTI-ITSLEPFO DBA Support (Govt. of India) – Oracle DBA

Broadline Computer Systems April 2010 – Feb 2012

SDMIS Govt. of MP -SQL Developer/DBA

Education:

Graduate in Computer Application (BCA) from VBS PURVANCHAL University. UP. India (2003-2006)

Masters in computer application (MCA) from VBS PURVANCHAL University UP. India (2006-2009)