SUMMARY:

• An accomplished IT professional holding around 9 years of experience, with a broad set of technical skills gained through a variety of roles ( Database Administrator, Projects DBA, SME, Database Architect and Engineering Team Manager ) which have been performed in large, complex and dynamic environments.
• Technical experience with Oracle 9i/10g/11g/12c, RMAN, RAC, ASM, AWS EC2, Oracle streams, Oracle Golden Gate, Amazon RDS, OAS, ODI, OBIEE, Oracle Internet Directory/ LDAP, Linux, Solaris, Windows, AIX + HACMP, Tru64, TWS, Legato, Commvault, CyberArk, ESM also working on MS SQL + associated toolset as secondary skill set.
• Extensively worked on AWS EC2 implementations and migrations from on - premise to cloud, designed firewall rules to allow communication between on-premise and AWS cloud.
• Designed and Implemented HA/DR for AWS cloud solution using Oracle 12c R1 and FSFO in Availability zones AZ1, AZ2 and Observer running on-premise .
• Implemented various high availability disaster recovery solutions like Data Guard FSFO, Data Guard physical standby, 3-node RAC also have experience working on non-RAC high availability solutions like AIX HACMP.
• Performed in-place and out-of-place upgrades .
• Proficient in Planning, Designing, Installations, Upgradations, Migrations, performance tuning, troubleshooting day to day issues, recoveries, database security, licensing matters, cloning and patching.
• Implemented snapshot standby approach for performing DR tests saving resource utilization and increasing DR availability.
• Expert in tuning system performance, can read and interpret AWR/ASH/ADDM/Statspack reports, setting up SQL profiles wherever required, SQL tuning using Explain plans and TKPROF.
• Hands-on experience in using 11g Grid control and 12c cloud control for performance monitoring, performing index rebuilds, looking for fragmented objects, blocking sessions, long running sessions and taking proactive actions.
• Data migrations using Logical backups i.e. legacy exp/imp or datapump and also using TTS (transportable tablespaces) wherever applicable.
• Data migrations using RMANcloning, active duplicate and restores from Legato or Data Domain .
• Performing regular HA/DR exercises to prove both High Availability and Disaster Recoveries working as expected.
• Expertise in setting up Oracle 12c Cloud Control Enterprise manager and handling end to end management of OEM 12c suite, also installed 12c agents on database servers both on-premise and on AWS cloud.
• Expertise in Golden Gate Installation, configuration and end to end management/troubleshooting and tuning of Golden Gate replication technologies.
• Expertise in setting up reporting environments using Oracle Streams, Oracle Golden Gate, Data Guard Active/Logical Standby
• Automated many common tasks using Crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Migrated number of databases from Non-ASM to ASM .
• Hands on experience in Managing Clusterware components using SRVCTL and CRSCTL utilities.
• Installation, Administration and Maintenance of SQL Server Instances.
• Have experience working on MS SQL as secondary skill set, also have administrative knowledge on MySQL.
• Experience in Migrating databases to Oracle Exadata Database Machine for different clients.
• Responsible for managing the DBA team (10+) to work effectively in a business-critical production environment and in 7x 24 supports. Good history of bringing the DBA team and IT team to enhance the productivity.
• Notable achievements include identifying new IT capabilities, influencing decision makers, generating funding and then going on to successfully deliver them through good team management.
• I work effectively with third parties, suppliers and specialized technicians while maintaining a keen business perspective and I find customers appreciate my ability to focus on business needs (not technology) while translating technical issues into plain English.
• Attending incident bridges for any production issues and working with app team to solve the issues at earliest. Made sure that client SLA is maintained for all level severity issues.
• Directed the team to implement proactive database monitoring, and automation of database maintenance, diagnostic reports, databases reports ®ular database operation tasks.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Linux, Solaris, AIX, HP-UX, Windows 2008 R2/12

DATABASES: Oracle 9i/10g/11g/12c, MS SQLRDBMS 2008R2/12/14, MySQL

TECHNOLOGIES USED: Data Guard(Physical/Logical/Active), FSFO, RMAN, Oracle Streams, Golden Gate, RAC, ASM, OVM, performance tuning specific tools, Exadata, Shell scripting, Python, OAS 10g, ODI 11g and OBIEE 11g, Oracle 12c CDB/PDB, OID/LDAP, SQL server 2008 R2/2012/2014, SSIS, SSAS, SSRS.

APPLICATION PACKAGES: Toad, SQL Developer, Dimensions, workflow builder

CLOUD TECHNOLOGIES: AWS EC2 (IaaS), AmazonRDS (PaaS) and Azure

TICKETING TOOLS: Open Pursuit, Maximo, Ticket Director, Remedy

UTILITIES: Export/Import, datapump, tkprof, Amazon S3

MONITORING TOOLS: OEMGrid Control 10g/11g and Cloud Control 12c, Hobbit, SCOM, Perceiver.

BACKUP AND SCHEDULING TOOLS: Legato, Commvault, Data domain and TWS

SECURITY TOOLS: CyberArk, ESM

PROFESSIONAL EXPERIENCE:

Confidential, Trumbull, CT

Lead Database Administrator

Responsibilities:

• Designed and built Oracle 12c R1 capability for Unilever on AWS cloud EC2 .
• Implemented disaster recovery and high availability solutions across multiple availability zones (AZ1, AZ2)
• Designed and Implemented Oracle 12c R1 HA with observer (running on premise) DR with Data Guard Physical standby .
• Commvault as backup solution, worked along with backup team to implement same for database backups, this is one of the cloud solution.
• Part of the security design team, produced standard format for firewall rules to allow traffic within AWS servers, from on premise to AWS and vice versa.
• Migrated Oracle databases from on premise servers to AWS EC2 instances.
• Performance monitoring and troubleshooting during build phase as well as during PGLS support using diagnostics pack, AWS Cloud Watch and on premise server level monitoring ( SCOM ).
• Designed and implemented Observer setup (part of HA solution called FSFO - Fast Start Fail Over ) on premise.
• Planned and implemented HA/DR (High Availability/Disaster Recovery) testing.
• Installed Cloud control agent on AWS servers configured them to be monitored by EM manager 12c cloud control running On-premise.
• Installed and configured 3-node 11g R2 RAC systems with ASM storage.
• Performance tuning using AWR/ADDM/ASH reports, setting up SQL profiles wherever required to allow explain plan stabilization.
• Implemented various solutions running on oracle 11.2.0.2/11.2.0.4/12.1.0.2, migrated databases from legacy versions like 8i/9i/10g to 11g/12c .
• Database refreshes using RMAN or export/import utilities.
• Testing of new Oracle releases and Critical Patch Updates (CPUs)
• For service criticality systems implementing HA solution using AIX HACMP and disaster recovery using data guard physical standby setup across site with maximum availability and real time apply.
• Working on various projects, including migrations from EOL (End of life) Oracle Databases on Tru64 to OVM and migration of Recovery Manager Catalog from 10gR2 Tru64 to 11gR2 AIX.
• Setup flashback normal /guaranteed restore points as part of application testing, flashback database in case of back out using flashback database feature in 11g.
• Involved in PAM CyberArk tool setup to maintain Oracle privileged accounts like sys/system etc.
• Performed capability for ESM (Enterprise Security Management) agent install on Oracle servers which fetches compliance data for security teams.
• Upgrades - upgrade databases to 11.2.0.4 from 10g/9i and to 12.1.0.2 from 11.2.0.2/3/4 applying patch sets to KFS databases regularly.
• Golden Gate Installation, configuration and end to end management/troubleshooting and tuning of Golden Gate replication technologies.
• Implemented Golden gate replication methods between multiple databases,unidirectional and bi-directional.
• Oracle 12c CDB/PDB related capability work started recently, evaluating and documenting all underlying features.
• As part of Amazon RDS working on MySQL capability.
• Developed and implemented audit scripts which run on entire estate on weekly basis and fetch report for audit team, this data is been supplied to Oracle on yearly basis.
• Took part in various solution discussions like F5 (load balancer), MFA (multi factor authentication) and Microsoft Remote Desktop Services which are newly implemented as part of AWS capability.
• As part of the data guard observer HA solution proved and documented various test case scenarios.
• Recently started working on AWS relational database services called RDS (PaaS), capability work is in progress for Oracle database.
• Migrating databases to Oracle Exadata Database Machine and administering them.
• Performing SME role for new projects on boarding, discussing and proposing various solutions as per the requirement.
• As part of RMO (resource management office) have been assigned to various projects as Database Architect/SME, design and implement the solutions for projects.
• Working closely with solution architects in finalising the solution design.
• Preparing build guides and SOPs (standard operating procedures) for team’s use.
• Chair BQC (Business Quality Circle) meetings discuss various technical issues, identify service improvement areas, co-ordinate and work towards fixing them.
• Running capabilities around new features for future builds
• Database performance diagnosis
• Closely working with scheduling team for setting up schedules for all setup using TWS (Tivoli Workload Scheduler), monitor, verify and ensure they are scheduled as expected and running fine.
• Closely working with backup team in case of setting up backups for new systems or during migrations ensure target system can read backup pieces from legato servers, helping backup team in troubleshooting any media management layer related issues.
• Closely working with UNIX team to install TWS, legato and ensure service is built as per the standards all Oracle recommendations are met.
• Currently part of OVM capability project, its main focus is on consolidating and optimizing the resources in turn saving money for the client.
• Incident analysis, problem management, finding out trends and suggesting best practices.

Environment: Oracle 12c/11g/10g/9i, AWS EC2, Data Guard (Physical standby), Data Guard (Physical standby, FSFO), OEM cloud control 12c, OEM grid control 11g, Golden Gate, RAC, ASM, Exadata, Linux, AIX, Tru64, Windows, OVM, RMAN, Export/Import, Datapump, OID/LDAP, Oracle 12c CDB/PDB, PAM CyberArk, ESM, TWS, Legato, Data domain, Amazon RDS, Amazon S3.

Senior Database Administrator

Responsibilities:

• Database refreshes - Keep non-production databases up to date wherever required using RMAN cloning/active duplicates, data pump and traditional export import .
• Database upgrades - Keep the databases and associated technologies on relevant agreed versions of software, applying appropriate patches and upgrades as required, upgraded databases from 9.2.0.4 to 11.2.0.2 and 10.2.0.4,10.2.0.5 to 11.2.0.2
• Setup and manage Oracle streams replication 10g/11g .
• Designed and migrated streams setup running on 10g onto newly built 11g database.
• Troubleshooting streams replication problem, actively using 12c cloud control to monitor Oracle streams.
• Performed capability work on Golden Gate, installed and configured to test unidirectional and bi-directional replication.
• Extensive experience in administering databases via OEM grid control 10g/11g and cloud control 12c .
• Implemented cloud control 12c and installed agents remotely.
• Migrating databases from non ASM to ASM .
• New server builds using ASM technology on 11.2.0.2 .
• As part of this project we have built total 47 new systems each with 3-node RAC setup .
• Implemented 3 node RAC setups (11.2.0.3.1 ) DB storage is ASM and having standby setup .
• Performed Disaster Recovery tests for 3 node RAC setups having standby.
• Performed node addition and removal tests as part of pre-requisite checks of new setups.
• Performing data migrations using RMAN or import/export or data pump
• Troubleshooting performance issues using diagnostic and tuning packs.
• Installing cloud control agent on RAC nodes configuring and monitoring systems.
• Real Application Testing for critical systems where workload performance is tested from old system to new system.
• Manage releases of application code to databases as required.
• Database monitoring - Wherever possible, identify, anticipate and resolve problems and issues before they happen by using the appropriate database monitoring tools (where available), we use OEM grid/cloud control, TOAD and few monitoring scripts placed to check the same.
• Creation and maintenance of databases - Create and maintain Oracle and associated technologies during their life cycle
• Database backup and recovery and management of database disaster recovery - Ensure we have up to date usable backups of databases and/or DR solutions in place
• Database performance - Ensure the database works efficiently and perform to agreed SLA standards
• Diagnosis and resolution of database problems – Investigate any problems found and work with appropriate people to provide solutions
• Database security – Ensure only the right people can use the database, that they have the correct access and that the correct procedures are being used
• Keep up with current issues, releases and developments in database and other relevant technology areas
• Support projects and progress – Understand the requirements for databases, the direction client is taking and the software companies are going so that we are placed to provide high quality support and advice on databases and the surrounding technologies
• Installation and configuration of ODI 11g environment, Starting and stopping agent, troubleshooting issues with ODI as well as supporting app team deployment work.
• Installation and configuration of OBIEE 11g, starting/stopping/troubleshooting OBIEE services, RPD migrations and supporting other release related activities.

Environment: Oracle 11g/10g/9i, Data Guard (Physical standby/ logical standby), RAC, ASM, Oracle streams, Oracle Golden Gate, OEM grid control 11g, Linux, AIX, Tru64, Windows, OVM, RMAN, Export/Import, Datapump, PAM CyberArk, Data domain, Legato

Database Administrator

Responsibilities:

• Installation and creation of Oracle 10g/9i Databases on Sun Solaris, Red Hat Linux, AIX, Windows environment
• Creating primary database storage structures (Tablespaces), resizing the data files, adding new data files etc.
• Rebuilding indexes and gathering statistics when needed.
• Created roles and profiles and assigned them to users. Created/removed database users.
• Extensively used Export/Import utilities for selective backup.
• Used standby database for doing different operations like application testing, disaster recovery testing and for reporting purposes etc.
• Cloning databases using RMAN, datapump and legacy export/import.
• Worked on multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster, DB storage as ASM .
• Generating AWR, ASH reports regularly to monitor the system.
• Taking oracle traces and providing the output of Tkprof and explain plan utilities to the development team.
• Configured and maintained Data Guard (physical standby database).
• Performed switchover and failover testing using DataGuard FSFO .
• Restore archive logs to standby database ensure both primary and standby are in sync.
• Troubleshooting day to day issues
• Installing and configuring databases
• Regular maintenance of databases, applying patches to adhere to compliance matters.
• Tuning system performance, identifying IO bottlenecks, looking for top CPU consuming resources and taking appropriate action by consulting app teams.

Environment: Oracle 11g/10g/9i, Data Guard (Physical standby/ logical standby), OEM grid control 11g, Linux, AIX, Windows, RMAN, Export/Import, Datapump.

Database Administrator

Responsibilities:

• Migrated/consolidated various systems (applications) from one data centre to another.
• Played key role in consolidating systems running in different data centres into one central location as part of optimization program.
• Co-ordinating with various teams like windows, backup, storage and UNIX.
• Migrated old version Oracle databases onto new infrastructure running on 11g .
• Based on the service criticality levels designed and implemented high availability and disaster recovery solutions.
• Closely worked with UNIX team for implementing high availability solutions for databases using AIX HACMP also data guard physical standby setup for DR.
• Performed Disaster Recovery tests for SC1/DR1 and SC2/DR2 service criticality level systems before go live.
• Performing refreshes using RMAN, Export/Import and Datapump
• Troubleshooting day to day issues.
• Capacity planning and resizing datafiles, tablespaces etc.
• SQL tuning using Tkprof and explain plans, setting up SQL profiles, looking for long running queries, gathering adhoc statistics and identifying blocking sessions etc.
• SQL server 2008 R2/2012/2014 RDBMS builds and users setup
• SSIS Installation, users and proxy setup.
• SSIS Deployment using manifest and batch files.
• Setting up multiple SSRS databases
• Database capacity uplifts
• SQL deployment related activities
• Linked server setup, granting required permissions
• SSAS builds and Users setup
• Database size optimization and space analysis.
• Backup and restore databases.
• Migrating databases from one instance to another.

Environment: Oracle 11g/10g/9i, Data Guard (Physical standby), OEM grid control 11g, Linux, AIX, Tru64, Windows, OVM, RMAN, Export/Import, Datapump, PAM CyberArk, ESM, TWS, Legato, Data domain, OID/LDAP, MS SQL 2008 R2/2012/14, SSIS, SSRS, SSAS, PAM CyberArk, ESM, TWS, Legato.

Database Administrator

Responsibilities:

• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
• Generating performance reports using AWR SQL Reports, ASH Reports, ADDM, and Cloud Control
• Cloning/duplicate of database with RMAN (Recovery Manager) and user managed backups like hot or cold backups.
• Performing schemas refresh/Database refreshes using legacy exp/imp and datapump .
• Maintain and monitor the physical layout of Disk storage, table spaces, data files, and object extents.
• Implementing the incremental, cumulative incremental and full RMAN backup for each database to have space management and effective recovery.
• Troubleshooting and fixing issues with Physical standby(DR setup)
• Configuration of table space and Archive utilization scripts through Crontab.
• Applied latest releases of the RDBMS patches from Oracle to the Production and test instances to resolve few technical challenges & issues.
• Prepared standard build guides, SOPs (standard operating procedures) for teams use.
• Setting up reporting environments using data guard logical standby .
• Looking for long running sessions, identifying and cleaning up blocking sessions.

Environment: Oracle 11g/10g/9i, RHEL, AIX, Unix, RMAN,Export/Import, OEM Grid Control, PUTTY.