SUMMARY

• Database Consultant with experience in Database Administration, Golden Gate (Classic and Integrated), Migration, Design, Development, Implementation, Monitoring/Alerting and managing enterprise class applications with focus on database performance, scalability and high availability.
• Skilled in designing infrastructure and implementing technology to support large user groups
• Proven track record of supporting small, medium and large Operational/Development database environments (Data Marts, Data warehouse, OLTP).
• Proven in - depth experience in database/application performance tuning, environment setups, security, backup, disaster recovery.
• Experienced in capacity planning, trouble shooting, and change control activities.
• Proven ability in Service excellence, Consulting, Problem Solving and Relationship Management.
• A good team player, like to work in a challenging environment
• Good experience in SQL Server 7, 2000, 2005, 2008, 2012, 2014 and 2016.
• Oracle Certified Professional(OCP 7.3,8,8i,9i,10g)

TECHNICAL SKILLS

Databases and Tools: Oracle (7, 8, 8i, 9i, 10g, 11g,12c), Grid Infrastructure, Oracle Grid Control, ASM, Oracle Enterprise Manager, RMAN, Exadata, Oracle Golden Gate, Quest Spotlight, TOAD, SQL Navigator, SQL Loader, Logminer, Oracle Discoverer, SQL Server, MS ACCESS

Operating Systems: Linux (Red Hat, Oracle Linux, SUSE), Confidential AIX, HP-UX, Solaris, Windows, DOS

High Availability Solutions: Oracle Grid Infrastructure, Oracle Clusterware 12c, 11g, Oracle standby/Data Guard, SQL Server (Clustering, Log Shipping, Database Mirroring, Replication, AlwaysOn)

Languages: SQL, PL/SQL, TSQL, Java, Perl, C/C++, HTML, Unix Shell Scripting (bash, ksh, sh).

Change Control: ClearQuest, Remedy, ServiceNow

PM/DB Design: MS Project, Visio.,ERwin, Oracle Designer 2000

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Consultant

Environment: Oracle 11g R2, Oracle 12c, Linux, Solaris, Ellucian Banner, Oracle ODI.

Responsibilities:

• Worked on Ellucian Banner migration project
• Managed Users/Accounts in Banner
• Migrated Data for ODS (Operational Data Store)
• Worked for Oracle ODI (Oracle Data Integrator) project

Confidential

Oracle Database Administrator

Environment: Oracle 11g R2, Oracle RAC 12c, Linux, Exadata, Oracle Cloud.

Responsibilities:

• Built Oracle 12c databases for different projects simultaneously on Exadata
• Worked on CRM host migration project
• Supported teams working on IFRS project
• Created POOLS, ZONES on Exadata for DBAAS projects
• Created different type of templets (Plastic, Bronze, Silver, Gold and Platinum) for DBAAS project
• Resolved different critical issues for DBAAS project with the help of Oracle support
• Worked on Oracle Public Cloud for HR and BICS projects
• Worked on OKV (Oracle Key Vault) migration project.

Confidential

Sr Technical Consultant/DBA

Environment: Oracle 11g R2, Oracle RAC 12c, SQL Server 2014, Confidential AIX, 12c Grid Control.

Responsibilities:

• Build and deployed Oracle 12c RAC for OnPrem servers.
• Build 11g RAC to deploy Applications not certified for 12c RAC
• Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV's.
• Creation of Always On groups, Troubleshoot Cluster & Always On for SQL Server 2014;
• Worked on Development and UAT environments.
• Worked for 12c RAC build on SoftLayer for Guidewire
• Applied lasted Oracle Patch sets on Oracle clusters.
• Mentor other DBA and Application teams for new projects
• Validated and fixed issues in Real Application Clusters using Orachk.
• Created Pluggable databases as required by different vendors.
• Generated scripts to refresh different Pluggable databases from golden images
• Deployed different servers like PentaHo, BA, PDI and Cloudera according to vendor’s requirements
• Support Application teams during application servers deployment.
• Worked on Database hardening as per Confidential standards.

Confidential

Oracle Golden Gate Consultant

Environment: Oracle Golden Gate 12c, Oracle 11g R2, Oracle RAC 12c, Confidential AIX, 12c Grid Control.

Responsibilities:

• Installed Oracle Golden Gate 12c on different RAC servers.
• Oracle Golden Gate 12c replication setup (Active-Active, Bi-directional) for high availability.
• Involved in non-functional testing for OGG.
• Configured CDR (Conflict Detection and Resolution) for approx. 200 tables.
• Participated in functional testing of OGG CDR and analyzed resolved/discard transactions to reconfigure the resolution strategies.

Confidential

Sr. Database Consultant

Environment: Oracle 11g R2/R1, Oracle RAC 11g R1/R2, HP-UNIX, Confidential AIX, Toad, Oracle Linux,12c Grid Control, Oracle Grid Infrastructure, Clusterware, SQL, PL/SQL, T-SQL, RMAN, ASM, AWR, Active Data Guard, VMWare Virtualization, Veritas Netbackup,DB2, MS SQL Server 2008/2012

Responsibilities:

• Involved in architecting/designing for providing database solutions for Distribution Centers.
• Worked on designing and implementing Oracle Maximum Availability Architecture Solutions (MAA) using Oracle Data Guard, Active Data Guard and Real Application Clusters (RAC).
• Built and deployed 20+ Oracle Grid Infrastructure, Oracle RAC (11gR2) and Oracle Data Guard setup in production/non-production environments.
• Installed, configured Oracle EM 12c for all of the production and non-production databases and setup rules/metrics to send alerts/incidents to on-call DBA.
• Installed and Configure MS SQL Server 2008 clustered environment (Add Nodes, Remove Nodes from cluster).
• Supervised code review of scripts and SSIS packages with developers.
• Installed and configured Oracle 11gR1/R2 for standalone database environments.
• Planned and executed database disaster recovery (DR) exercises (using RAC, Data guard).
• Well versed in Oracle upgrades and patching procedures.
• Identified performance tuning opportunities, implemented improvements to improve system response and run times, and advise developers on SQL tuning options.
• Performed day-to-day database monitoring and performance tuning using Oracle standard tools and dynamic views.
• Involved in a number of Oracle performance tuning and troubleshooting issues related to CPU, memory, I/O, disk space and other types of resource contention.
• Worked on implementing various database solutions e.g. managing physical data storage, various replication solutions, database maintenance, statistics and integrity checks.
• In-depth knowledge of Oracle database internals, data structures, and configuration parameters.
• Responsible for planning, development and execution of RMAN backups, data loads, exports, gather DB stats,Re-orgs
• Supported multiple database on DB2 for day to day DBA tasks..
• Authored technical and support documentation including implementation plan, DBA handbook, installation checklists and upgrade guides.

Confidential

Senior Database Administrator

Environment: Oracle 11g R2/R1,10g/9i/8i, Oracle RAC 11g R1/R2, SQL Server 2000, 2005, Exadata, HP-UNIX, Confidential AIX, Data Warehouse, ETL, Toad, Oracle Golden Gate, Linux, OEM Grid Control, Oracle Grid Infrastructure, Clusterware, RMAN, ASM, AWR, Data Guard, VMWare Virtualization, Veritas Netbackup

Responsibilities:

• Configured and managed data replication using Oracle Golden Gate (Active/Passive, Active/Active)
• Monitored Golden Gate Extract/Pump/Replicate processes and configured Alerting
• Supported Golden Gate processes and fixed issues related to Extract/Replicate processes
• Installed, configured and supported Oracle 11g R1/R2, Oracle 11g RAC databases, Oracle Grid Infrastructure, ASM in various environments (HP-UX, Linux, AIX, Solaris)( in Production, UAT and Development)
• Experience with data modeling and schema design, database architecture and creating a high-performance, reliable and scalable solution
• Installed and upgraded development and test environment support and provided ongoing support to development and test teams.
• Managed SQL Server 2000 and 2005 for Switch Control applications and Work Force Management system.
• Creating logins, tune T-SQL queries, users & maintaining SQL Server system security in Prod, Dev & Test/UAT.
• Worked in Oracle upgrades and patching procedures.
• Performed day-to-day database monitoring and performance tuning using Oracle standard tools (statspack, AWR, ADDM, Oracle Advisors, tkprof) and Oracle dynamic views
• Performed pro-active database monitoring by installed and configuring database tools (OEM, Grid Control, Toad) and scripts and sent alerts to enable the DBAs to reduce outages
• Identified performance tuning opportunities, implemented improvements to improve system response and run times, and advise developers on SQL tuning options.
• Competent with general DBA responsibilities including: managing physical data storage, partitioning strategies, various replication solutions; database maintenance such as index, statistics and integrity checks
• In-depth knowledge of Oracle database internals, data structures, and configuration parameters.
• Interacted with business users and technical users to develop data requirements specifications.
• Performed database capacity planning related to database physical structure, growth and system utilization, trend analysis and predicted future database resource requirements.
• Maintained and assisted in the creation of security measures to safeguard against accidental or unauthorized damage, modification or disclosure.
• Responsible for planning, development and execution of RMAN backups, data loads, exports, gather DB stats, Re-orgs, database partitioning and maintenance
• Worked closely with other team leads and their technical teams (QA, PM, BA, Architecture) to ensure delivery of database services within the performance targets set.
• Worked with application teams to ensure coding standards in order to meet architecture efficiency and adhered to the best practices on the database and application level using strong knowledge of Query languge and Data Defination languge of supported DBMS.
• Worked with Oracle Support closely to resolve SEV.1, SEV.2, SEV.3 and escalated issues
• Mentored and worked with the other team members to transfer the knowledge
• Authored technical and support documentation including implementation plan, DBA handbook, installation checklists and upgrade guides
• Provided day-to-day 24X7 Production support (Primary & Secondary) to maintain UPTIME and SLA
• Involved in Sarbanes-Oxley (SOX) implementation using oracle profile.

Confidential

Senior Oracle DBA (Team Lead)

Environment: Oracle 10g/9i/8i, Oracle 10g Grid Control, HP-UNIX, Linux, Oracle Enterprise Manager, Oracle Application Server, ETL, TOAD, DBArtisan, SQL Server (7, 2000, 2005), Query Analyzer, DTS, RMAN, SQL, PL/SQL, JDBC, WebSphere, SQL Navigator,DB2, TOAD, ERWin, Sun Solaris 9/10, VMWare Virtualization

Responsibilities:

• Performed day-to-day database monitoring and performance tuning using Oracle standard tools (OEM, statspack, AWR, ADDM, Oracle Advisors, tkprof) and dynamic views
• Performed general DBA responsibilities including: managing physical data storage, partitioning strategies, various replication solutions; backup recovery, DB maintenance such as index, statistics and integrity checks
• Significant experience working with large-scale systems and data platforms/warehouses
• Served as the primary interface for the business to plan and decide various database projects
• Interacted with multiple teams (developers, tester, BA, DA, PM) and business partner on an ongoing basis
• Lead a DBA team of 5 members from intermediate to competent level
• Mentored in-house DBAs to assume higher levels of responsibility
• Performed Capacity Planning and proposed/implemented disk resource management
• Installed, configured and supported Oracle 10g (stand alone and RAC), Oracle Clusterware, Oracle ASM in various Unix/Linux and Windows environments
• Managed multiple DB2 databases (databases creation, backup, recovery, and tables maintenance)
• Installed and upgraded development and test environment support and provided ongoing support to development and test teams for Oracle and SQL Server databases.
• Working on T-SQL, query tuning Performing tasks, installation & configuration of SQL Server to perform efficiently.
• Configured, troubleshoot and managed Oracle Data Guard/Standby databases
• Setup/wrote Unix cron jobs using shell scripting/SQL/PL SQL for performing DBA related tasks
• Created logical/ERD and physical database design, logic flow charts and process diagrams.
• Mentored and trained peers/team members to tune PL/SQL using trace and explain plan outputs
• Consulted with and advised users on various database issues and works with internal and external teams.
• Project, planned and implemented long-range requirements for database administration and design.
• Specified data validation, verification and reconciliation strategies.
• Performed database and system Disaster Recovery exercise held annually at data recovery center
• Implemented database and application SOX security standards and removed vulnerabilities
• Worked on replication, standby database and RMAN in a very high availability environment
• Provided 24x7 support in production environment
• Troubleshoot and resolved critical database issues and outages
• Configured Database Encryption for highly secured databases

Confidential

Senior Oracle DBA/Analyst

Environment: Oracle Server 9i & 8i, Oracle Enterprise Manager, Solaris 8/9/10, AIX 5L,Veritas NetBackup, Oracle Designer 9i,e-Business Suite 11i (11.5.9)

Responsibilities:

• Support for more than 40 databases including VLDs (Tera-byte plus)
• Responsible for compliance with different levels of Service Level Agreements (Platinum, Gold, Silver, Bronze) using Remedy and USD.
• Support for DSS environment.
• Helped developers to tune the SQL scripts for Dataware house reporting.
• Responsible for support, maintenance and tuning of Standby database.

Confidential

Senior DBA(Service Bureau)

Environment: Oracle Server 9i & 8i, Oracle Enterprise Manager, Solaris 8, Citrix Forms, Veritas NetBackup, SQL*Navigator, TOAD, RMAN, SQL*Loader

Responsibilities:

• Technical Lead for Billing Production Service Bureau support to Primus Canada and Sears Canada
• Performance tuning of production environment for online batch transactions
• Root cause analysis for performance problems using statspack, System Statistics and Oracle Trace
• Backup and recovery planning and development of backup and recovery strategies using RMAN (VERITAS NetBackup)
• Involved with installation of ORACLE 9iRAC on 2 node cluster for high availability
• Installation, configuration and testing of Oracle 10G databases
• Prepared and implemented Disaster Recovery Planes for Production environments.
• Setup and testing of Oracle 9i Data Guard.
• Monitoring of the Alert logs and trace files using OEM.
• Java policy management for XML developers
• Database migration/upgrade planning and execution