SUMMARY

• I have more than 18 years of Oracle, and SQL Server and more than 20 years of total IT experience
• I have a thorough knowledge of Software development Life Cycle (SDLC).
• As a Senior DBA, I have the primary responsibilities for definition, creation, and maintenance of enterprise databases within the computing environments.
• Analyzes, test, and implements physical database design supporting various business applications (including base definition, structure, documentation, long - range requirements, operational guidelines).
• Ensures data recovery, performance tuning, maintenance, data integrity, and space requirements for physical databases are met through formulations and monitoring of policies, procedures, and standards relating to database management best practices.
• Provide a high degree of coordination between user, technical, application, and corporate entities to ensure effective data management as a corporate enterprise.
• Have a willingness to work with customers of varying levels of technical expertise in a high-pressure, complex environment.
• Above all ensures solutions meet business objectives, and establishes and maintains a high level of user trust and confidence in my knowledge of and concern for users’ business needs.
• Have a thorough knowledge of and configuration of interrelationship between oracle and non-oracle databases.
• Experienced managing Geographic Information Systems, SAP, Oracle Applications, Oracle Fusion Middleware, MySQL, DB2 and SQL Server.

TECHNICAL SKILLS

OPERATING SYSTEMS: UNIX - Sun Solaris, HP-UX, AIX, Linux, Windows Operating Systems

DATABASE/APPLICATIONS/TOOLS: Oracle 7x, 8x, 8i, 9i, 10G,11G, 12C, Oracle Exadata, SAP, MS SQL Server, Informix 59iAS;10g AS, Oracle Applications (Releases10x,11x & 11ix), Geographic Information Systems(ESRI’s ArcView, ArcInfo, Arcfm, ArcSde, Oracle Spatial, Oracle GoldenGate, Real Application Cluster(RAC); RMAN, Oracle ASM,OBIEE, SOA,Weblogic, Websphere; Siebel,Clarify (Clear Support, Clear Sales, Clear Logistics); Kronos, Dalleen Billplex (Billing Applications); Postgres, Granite Systems (Inventory mgt & Network Provisioning), MYSQL, Veritas Netbackup, SAP, Oracle Grid Control, Informatica, DBArtisan, UNIX Raw devices, EMC Storage, ERWIN, MS-Visio, Rational Rose tools, EMC Documentum, Quest Tools-Toad, Spotlight; Subversion, Clear Case, BMC Patrol, BMC's SQL Backtrack, Veritas Cluster, NetApp, TIVOLI Data Protection, Epic Cache

LANGUAGES: Pearl scripting; Shell scripting; PLSQL,C++, SQL, Perl, VBScript, COM, COM+, XML, Visual Basic, T-SQL,JAVA.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Responsibilities:

• I participate in all phases of various projects and make appropriate recommendations in accordance with Oracle database best practices for both OLTP and Data Warehouse environments. Review the logical model, ensuring the detailed physical design and data structures and databases complies with standards, guidelines, and procedure recommended for all aspects of data modeling, database design, and maintenance and also implemented the design recommendations.
• Performed application, database and server discoveries and documentations for data migration.
• Prepare and validate technical documentations ahead of migration schedule.
• Work with business, application team, System and database administrator to execute data migrations.
• Design and implementation of data conflict detection and resolution for Bi-direction replication.
• Perform in-place migration/move of database on Windows server and Unix from one data center to another.
• Perform online Oracle database migration across platforms and across database systems using RMAN, Transportable tablespace, data pump and export and import.
• Perform Oracle database and Oracle EBS migration to OCI and AWS cloud.
• Planning, design, implementation and support of Oracle 11GR2, Oracle 12C, Oracle EBS, Oracle Exadata Machine, Oracle Cloud, AWS, Oracle Real Application Cluster (RAC), Oracle Fusion Middleware, Sun Solaris, Linux, VMware, HP and AIX servers.
• Perform cross platform, in-place, single instance to RAC, Single instance to Oracle Exadata machine, and on-premise to cloud. Migrated pluggable and container databases to AWS.
• Installed various patches - upgrade patches, CPU patches, One-of patches, family packs etc.
• Perform upgrade and migration of Oracle databases from 10G,11G to Oracle 12C, 18C and 19C.
• Participate in planning, implementation, and growth of our infrastructure on Oracle Cloud Infrastructure, Amazon Web Services
• Perform OCI and AWS production server health checks and monitoring metrics .
• Experienced in backup services like EBS snapshots, S3 backups and Amazon Glacier (System Load, Swap Memory, Hard disk, Apache requests, Mailq) using Nagios and CloudWatch.
• Experience of Migration & Deployment of Applications with Upgrade Version of Applications.
• Manage AWS EC2 instances utilizing Auto Scaling, Elastic Load Balancing and Glacier for our QA and UAT environments as well as infrastructure servers for GIT and Puppet.
• Experience in setting up the Continuous Integration (CI) and Continuous Deployment (CD) practices for release automation of Java and Oracle Fusion Middleware Applications (Oracle ADF, Oracle SOA, OSB)
• Troubleshooting and resolution of AWS production server load problems such as parsing, mailq, query stuck.
• Planned, designed and implemented zero downtime cross platform migration using Oracle Golden for Oracle database migration and data replication across 4 regional data centers for different applications, including Oracle application.
• Use Real Application Testing (RAT) for databases to replaying actual production database workload in test environment to collect workload, CPU, memory performance statistics as a result of and as well as analyzing, identifying, fixing potential issues before deploying changes (schema, RAC, memory changes, OS and Database upgrades and fixes)to production.
• Provide Oracle database production support - undertake troubleshooting, research and resolution of complex database and application problems by closely monitoring and tuning database performance issues; identify problems and implement solutions; ensure the database is running at optimal speed and efficiency---tuning and optimization of Database Buffer cache, db cache, PGA, Library cache, Dictionary cache, SQL statements using scripts, Oracle Statspack, Oracle trace, TKPROF, Automatic Workload Repository (AWR), ADDM, OEM/Grid Control, spotlight, Toad, and DBArtisan.
• Lead the performance tuning and optimization efforts for Oracle databases.
• Migrated Oracle database running raw device and cooked file system to ASM storage.
• Integrated and replicated data across multiple Oracle, PeopleSoft and DB2 using Oracle heterogeneous services, DB2 Connect Gateway, db links, synonyms, snapshots and materialize views.
• Configuration and management of Data Guard (Active and Snapshot Data Guard) for Oracle RAC and standalone databases.
• Proactive monitoring of OS file system, I/O, CPU, SWAP, memory and network utilizations on UNIX and Windows 2000 and ensures efficient use of disk storage; Reclaim spaces; optimize space allocation and avoid out-of-space conditions.
• Created and maintained database table partitions, partitioned global and local indexes, materialized views, refresh groups, functional indexes to speed query performance for enterprise data warehouse.
• Wrote PL/SQL programs to automate database maintenance activities.
• Configure, deployment and management of backup and recovery strategies using RMAN, shell scripts, and Netbackup
• Database security Management, session management, set up database system, session and statement auditing strategies, creating and administering database users, roles, privileges and profiles to ensure compliance with enterprise, SOX Act and PCI security and control standards.
• Performs database re-orgs and index rebuilds to reclaim spaces and optimize database performance.
• Performed documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Server environment.
• Clone/refresh Informix instance.
• Installations, Management, Migration and upgrade MS SQL Server.
• Performance Monitoring and tuning of SQL Server OLTP/OLAP database server.
• Performance Monitoring using tools such as Quest Performance Analyzer, Quest Spotlight, BMC Proactive Net, SQL Sentry and others.
• Effectively and aggressively manage tasks to accomplish business goals and to adhere to established deadlines.
• Manage a combination of small, medium-sized and large scale projects in a fast-paced environment.
• Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.

Confidential, Atlanta, GA

Senior Oracle DBA

Responsibilities:

• Planning, design, and implementation of Oracle 10G, 11G, Oracle ASM, Oracle11GR2 Real Application Cluster (RAC), Oracle Applications 11i, Oracle Application server, 9iAS including on Linux, Oracle VMware, and Windows operating systems
• Planned, and Performed upgrade and migration of Oracle databases from 10G and 10gRAC to Oracle 11gR2 and Oracle11gR2 RAC respectively.
• Undertook troubleshooting, research and resolution of complex database and application problems by closely monitoring and tuning database performance issues; identify problems and implement solutions; ensure the database is running at optimal speed and efficiency---tuning and optimization of Database Buffer cache, db cache, PGA, Library cache, Dictionary cache, SQL statements using scripts, Oracle Statspack, Oracle trace, TKPROF, Automatic Workload Repository (AWR), ADDM, OEM/Grid Control, spotlight, Toad and DBArtisan.
• Configuration and management of Data Guard for Oracle RAC to stand alone and from Oracle RAC to RAC and standalone Oracle instances.
• Performed application, database and server discoveries and documentations.
• Prepare and validate technical documentations ahead of migration schedule.
• Work with business, application team, and System administrators to execute data migrations.
• Perform in-place migration/move of data from one data center to another.
• Perform online database migration across platforms and across database systems using RMAN, Transportable tablespace, data pump and export and import.
• Perform database consolidation from multiple database servers to supersized database server.
• Perform application data consolidation from multiple database sources into a 35 terabyte database
• Develop triggers to handle GoldenGate replication conflict and resolution.
• Architected, planned and implemented Oracle Golden Gate 11g and 12c (Classic and Integrated Capture) replicate oracle databases across 4 regional data centers for different applications, including Clarify Active-Active and Active-Passive Replication configurations
• Develop UNIX stored shell and Windows batch scripts for Golden Gate replication monitoring and alerting of issues.
• Planned, designed and implemented Oracle GoldenGate active-active, Bi-Directional Replication from Oracle Databases to SQL Server and from Oracle to Oracle database.
• Monitored OS file system, I/O, CPU, SWAP, memory and network utilizations on UNIX and Windows 2000 and ensures efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out-of-space conditions.
• Implemented, and maintained Oracle partitioning to distribute file system I/O, data archiving and database performance.
• Perform server consolidation of over 5T from multiple HP and AIX servers to Solaris.
• Perform database migration and system consolidation for ease of database and system administration.
• Created and maintained database objects such as partitions, partitioned global and local indexes, materialized views, refresh groups, snapshots.
• Reviewed the physical model created from the logical model, ensuring the detailed physical design and data structures and databases complies with standards, guidelines, and procedure recommended for all aspects of data modeling, database design, and maintenance.
• Developed, deployed and supported enterprise backup and recovery strategies, using RMAN, shell scripts, export & imports, data pump on Clustered and non-Clustered Servers Unix servers.
• Configuration of Oracle Data Guard for standalone and RAC databases from primary to remote and local standby's, including Active Data Guard.
• Assist developers in performing functional, unit and integration testing of applications.
• Use Real Application Testing (RAT) for databases to replaying actual production database workload in test environment to collect workload, CPU, memory performance statistics as a result of and as well as analyzing, identifying, fixing potential issues before deploying changes (schema, RAC, memory changes, OS and Database upgrades and fixes)to production.
• Database security Management, session management, set up database system, session and statement auditing strategies, creating and administering database users, roles, privileges and profiles to ensure compliance with corporate security and control standards, and SOX Act and PCI compliance.
• Performs database re-orgs and index rebuilds to reclaim spaces and optimize database performance.
• Performed documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Server environment.
• Refreshed Oracle databases and applications from one environment to another.
• Performed information gathering and documenting business rules, change management and integration related issues.
• Performed documentation, tracking, analysis, development, and validation of functional requirements and systems design.

Confidential

Senior Oracle DBA

Responsibilities:

• Design, and implementation of Oracle 10G, 11G, Oracle ASM, Oracle11GR2 Real Application Cluster (RAC), Oracle Applications 11i, Oracle Application server, 9iAS including on Linux, VMware, HP and AIX servers.
• Perform upgrade and migration of Oracle databases from 10G and 10gRAC to Oracle 11gR2 and Oracle11gR2 RAC respectively.
• Installation and configuration of Oracle Fusion middleware on standalone and clustered environments.
• Automation of various building and deployment processes through shell scripting,
• Maintained Load balancing, high availability and Fail over for the servers
• Configured and managed databases and connection pools.
• Extensively involved in tuning the application servers, database servers and the operating systems performance.
• Installation and configuration Oracle Cloud Control 12c and 13C for enterprise database management and monitoring.
• Undertook troubleshooting, research and resolution of complex database and application problems by closely monitoring and tuning of development and production database performance issues; identify problems and implement solutions; ensure the database is running at optimal speed and efficiency---tuning and optimization of Database Buffer cache, db cache, PGA, Library cache, Dictionary cache, SQL statements using scripts, Oracle Statspack, Oracle trace, TKPROF, Automatic Workload Repository (AWR), ADDM, OEM/Grid Control, spotlight, Toad and DBArtisan.
• Monitoring and tuning data loads into Oracle database data warehouse.
• Managing SAP databases using BR-Tools
• Configuration and management of Data Guard for Oracle RAC to stand alone and from Oracle RAC to RAC and standalone Oracle instances.
• Implemented and managed Oracle GoldenGate and Veridata for heterogeneous and bi-replication data replication.
• Performed zero downtime cross platform migration using a combination of Oracle Goldengate, Oracle Transportable Tablespace and RMAN from Oracle to Oracle.
• Performed Oracle 10G database upgrade to 11G with zero downtime using a combination of Goldengate, Oracle Transportable tablespace and RMAN.
• Performed migration of Oracle databases to SQL Server as part of enterprise license cost and maintenance reduction efforts.
• Performed data center migration and database consolidations for multiple clients.
• Monitored OS file system, I/O, CPU, SWAP, memory and network utilizations on UNIX and Windows 2000 and ensures efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out-of-space conditions.
• Implemented, and maintained Oracle partitioning to distribute file system I/O, data archiving and database performance.
• Perform server consolidation of over 5T from multiple HP and AIX servers to Solaris.
• Perform database migration and system consolidation for ease of database and system administration.
• Created and maintained database objects such as partitions, partitioned global and local indexes, materialized views, refresh groups, snapshots.
• Reviewed the physical model created from the logical model, ensuring the detailed physical design and data structures and databases complies with standards, guidelines, and procedure recommended for all aspects of data modeling, database design, and maintenance.
• Developed, deployed and supported enterprise backup and recovery strategies, using RMAN, shell scripts, export & imports, data pump on Clustered and non-Clustered Servers Unix servers.
• Assist developers in performing functional, unit and integration testing of applications.
• Use Real Application Testing (RAT) for databases to replaying actual production database workload in test environment to collect workload, CPU, memory performance statistics as a result of and as well as analyzing, identifying, fixing potential issues before deploying changes (schema, RAC, memory changes, OS and Database upgrades and fixes)to production.
• Performed management and administration of Informix databases/instances
• Database security Management, session management, set up database system, session and statement auditing strategies, creating and administering database users, roles, privileges and profiles to ensure compliance with corporate security and control standards, and SOX Act and PCI compliance.
• Performs database re-orgs and index rebuilds to reclaim spaces and optimize database performance.
• Performed documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Server environment.
• Refreshed Oracle databases and applications from one environment to another.
• Performed information gathering and documenting business rules, change management and integration related issues.
• Performed documentation, tracking, analysis, development, and validation of functional requirements and systems design.