SUMMARY

• Twenty (26) plus years of IT experience in executing major projects and providing production support across multiple hardware and software platforms.
• Fifteen (15) plus years of Oracle7.x, 8.x/ 8i/ 9i/10g/11g/12c DBA experience.
• Two Plus years of experience on Exadata.
• Three Plus Years of experience in 12C OEM.
• 12C Database Upgrade experience from oracle 10G.
• Good Experience in High Availability - RAC (Real Applications Cluster) environment.
• Good Experience in Disaster Recovery - Data Guard and RMAN.
• Good knowledge in relational and NoSQL databases like MySQL, MariaDB, Postgres, SQLServer, Oracle, DynamoDB, MongoDB.
• Possess good knowledge in creating and launching EC2 instances using AMI’s of Linux.
• Two Plus Years of experience with the SQL Server DBA and PeopleSoft DBA.
• Ten plus years of experience with the C, SQL, PL/SQL, Pro*C and UNIX shell scripting.
• Five Years of Team Leadership and Project Management experience
• Strong in advanced features like Partitioning, Replication, Standby databases (Data Guard).
• Excellent oral & written Communication skills, Technical & Analytical skills. Efficient Team leading and Project management skills, systems analysis & design skills.
• Offshore model Experience, SCRUM/Agile methodologies.
• Strong database analysis, logical and physical database design and data modeling experience using
• Various CASE tools.
• Feasibility study of Heterogenic/Homogenous DB migrations from on premise VMs to EC2 or RDS andOracletoPostgres/MySQL/Oracleusing tools like Schema conversion tool and estimation on level of effort to convert these databases and migration of VM’s to AWS EC2/RDS using DMS.
• PeopleSoft DBA experience including installation, Patches, Cloning and maintenance of the PeopleSoft Financials and HRMS modules.
• Expert level skills in ORACLE ENTERPRISE MANAGER(OEM), DBArtisan, Toad, ORACLE SERVER 11g/10g/9i/ 8i/ 8.x/ 7.x, and Developer 2000/ 9i tool set.
• Installing, Configuring, monitoring and maintaining Oracle Software 11g,10g/9i/8i/8.x/7.x including cluster ware on Sun Solaris 2.6/ 8.0/9.0, HP-UX 10.2/11/11i, AIX 4.2 and Windows NT/2000 Platform.
• Extensive expose with very large database (VLDB).
• Extensive experience in the Database Administration activities such as:
• Installations and patches of RAC and Oracle Stand alone servers
• Database Creation, configuration, maintaining, monitoring and developing
• Database Migration / Upgradation from 8i to 9i, 10g and 11g
• Database Security Administration
• Database Performance Tuning / Application Tuning / SQL Tuning
• Database Space management
• Database Physical/ Logical Design and development with help of ER-WIN
• Database Backup and Recovery - RMAN and SVRMGR
• Developing/Writing a PL/SQL, Stored Procedures, Packages, Functions, Triggers and Pro*C Programs
• Configuring SQL*NET, Oracle Names Server.
• Configuring and maintaining Multi-threaded Server
• Database Object Administration - Create, Alter, Drop, Grant Privileges, Block Management, Space Management
• Writing a Shell script for the Automate Online backup for Unix Platform
• Expert level skills in using third party tools to admin database like - TOAD, SQL Navigator, Quest Central

TECHNICAL SKILLS

Hardware Platforms: HP-9000, IBM RS 6000, SUN SOLARIS

Operating systems: UNIX, Linux, DOS and Windows NT/2000.

Languages: C, C++, Pro*C, SQL and PL/SQL.

Database: ORACLE 6/7.x/8.0.5/8i/9i/10g/11g,12C, SYBASE v4.2, SUPRA, PostgreSQL and Informix.

ERP: PeopleSoft 8.0.

Front-end Tools: Developer 2000 (FORMS 4.5/6i, REPORTS 2.5/6i)

CASE Tools: Designer 2000 and ERWIN/ERX 3.5/4.x.

PROFESSIONAL EXPERIENCE

Confidential, Overland Park

Database Manager/Sr. Oracle Database Administrator/Dev

Responsibilities:

• Responsible for architecting, designing, implementing and supporting of cloud based infrastructure and its solutions.
• Proficient inAWSservices like RDS, VPC, EC2, S3, ELB, AutoScalingGroups (ASG), EBS, RDS, IAM, Route 53, Cloud Watch.
• Experienced in creating RDS instances to serve data through servers for responding to requests.
• Written Templates forAWSinfrastructure as a code using Terraform to build staging and production environments.
• 24x7 production systems Database support
• Implemented RMAN backups (FULL and INCREMENTAL).
• Worked on AWS, MYSQL, PostGress and MongoDB.
• Upgraded 10.2.0.4 databases to Oracle 12C..
• Work toward replacing expensiveOracledatabases with open-sourcePostgresdatabases as appropriate.Explore compatibility issues between the two RDBMS’s, focusing on the differences betweenOraclePL/SQL andPostgresPL/pgSQL.Generate a source code patch causing PL/pgSQL zero-row queries to leave target variables untouched, matching the behavior of PL/SQL.Patch is accepted into main source tree.
• Database restored and recovered numerous times in both Production and Test Systems.
• Troubleshooting, backup and recovery, proactive database and system maintenance, proactive monitoring, security, research and development, all levels of performance tuning, architecture and design, mentoring, and support
• 24x7 production systems Database support
• Analyzing AWR, ADDM and ASH reports for optimal performance.
• Used SQLT tool for performance Issues.
• MigratedOracleDB/Postgres/MySQL running on premise to RDS using DMS.
• Monitor Objects growth and provide DB capacity planning for application expansions.
• Designed and implemented daily database monitoring check list for all the databases.
• Troubleshoot and fixed the site wise major performance problem.
• Administration, scheduling jobs, monitoring, restores and backups in SQL Server Databases.

Environment: AWS(EC2, VPC, ELB, S3, EBS, RDS, Route53, ELB, Cloud Watch,AWSAuto Scaling, PostgreSQL, GIT, SQL, JIRA,AWSCLI, Unix/Linux, Shell scripting, Jenkins, Terraform.

Confidential, Lenexa

Sr. Oracle Database Administrator

Responsibilities:

• Upgraded 10.2.0.4 databases to Oracle 12C.
• Completed moving single instance databases to EXADATA machine.
• Installed several 12c,11g/10g RAC clusters and Databases on Sun Solaris, Linux platform with ASM storage for our production systems.
• Installed OEM grid control and OEM 12C solution to monitor all the Production Databases.
• Database restored and recovered numerous times in both Production and Test Systems.
• Troubleshooting, backup and recovery, proactive database and system maintenance, proactive monitoring, security, research and development, all levels of performance tuning, architecture and design, mentoring, and support
• Used various AWS services like S3 bucket, DMS, SCT for migration topostgres.
• 24x7 production systems Database support
• Implemented RMAN backups (FULL and INCREMENTAL).
• Analyzing AWR, ADDM and ASH reports for optimal performance.
• Used SQLT tool for performance Issues.
• Hands-on experience migratingOracle, SQL Server instances to AWSEC2(OracletoOraclemigration,OracletoPostgresmigration,Oracleto MySQL)
• Monitor Objects growth and provide DB capacity planning for application expansions.
• Designed and implemented daily database monitoring check list for all the databases.
• Troubleshoot and fixed the site wise major performance problem.
• Manage allOracle9i and 10g databases for Internet payment processor.Work closely with CIO to develop PL/SQL code objects to enforce business rules and ensure transaction integrity.Work with auditors to hardendatabaseto pass industry security audit.PromotePostgresasOracle replacement where appropriate, patchingPostgressource code forOraclecompatibility.
• Implementation of Oracle Data guard (Physical Stand by) data base.
• Management of schemas, objects & partitioning the tables including IOT tables & indexes.
• Administration, scheduling jobs, monitoring, restores and backups in SQL Server Databases.

Confidential, Topeka

Responsibilities:

• Lead a group of 10 data analysts and database administrators in support of Market Grid applications.
• Performed forecasting for each employee for approved work on an ongoing basis.
• There were over 70 databases in this account.
• The databases were on the following platforms. UNIX Oracle 8 and 9, SQL Server, UDB and Mainframe DB2.

Confidential, Overland Park

Responsibilities:

• Install, configure, and upgrade software: server, tools, and applications from Oracle7.x/8.x/8i/9i/10g.
• Supporting 24x7 production systems
• Logical and physical database design for various new development releases and implementation of new customers.
• Performed Archiving of old data from the production databases.
• Developed several modules using Unix Shell Scripting, PL/SQL, Pro*C and C.
• Designed, studied and Implemented DR solutions (Data Guard).
• Performed a Feasibility study for Compliance for migratingOracle, MySQL,PostgresServers from on premise to RDS and EC2.
• Implemented SQL-BackTrack and RMAN backups.
• Supported developers in tuning SQL’s and application for optimal performance.
• Analyzing STATSPACK reports on daily basis for optimal performance.
• Monitor Objects growth and provide DB capacity planning for application expansions.
• Designed and implemented daily database monitoring check list for all the databases.
• Implemented Oracle Names server to maintain developer’s local databases.
• Developed (automated) a UNIX shell scripts to refresh the Demo database.
• Troubleshoot and fixed the site wise major performance problem.
• Implementation of Standby Database.
• Designed and implemented the snapshot replication setup for reporting purposes.
• Monitor, tune, size, backup, recover, analyze, defrag, and migrate the database objects.
• Design and implement DB security, user management.
• Used SQL and PL/SQL: scripts, triggers, procedures, and packages to automate the projects.
• Used high availability features like partitions, standby database, RMAN.
• Coordinate with offshore development team and provide them advance problem analysis and suggestions.
• Design and implement backup methods and disaster recovery strategies.
• Migrate DB between software versions, platforms and DB products.
• Prepare and load the client data into Oracle database using SQL*LOADER.
• Interacted with Oracle support in regards to opening new TAR’s (Technical Assistance Request) and solving the existing TAR’s.
• Gained offshore model experience.
• Managed 4 production databases and more than 20 Development, systest, UAT, Acceptance and Demo databases.

Environment: Oracle 7.x/8.x/8i/9i/10g, PVCS, UNIX, C. C++, Pro*C, Developer 2000, PeopleSoft