PROFESSIONAL SUMMARY:

• Over all 9+ years IT Experience as an Sr. Database Administrator / Golden gate Expert / AWS Architect progressively responsible positions in diversified and very large production and development environments in various domains like Telecom, Health Care, Banking and Manufacturing with database implementation in various Operating system platforms.
• Extensive experience in Installation, Configuring, and Maintenance of Enterprise level Oracle (10gR2, 11gR2, 12c), MySQL databases.
• Extensive in implementing and handling Replication technologies (Shareplex, OGG, Oracle Streams)
• Experience in handling Multi - Terabyte Database migrations/Consolidations with minimum/no downtime.
• Proficient in implementing and maintaining Oracle Engineered systems (Exadata, Supercluster).
• Experience in coordinating and implementing Oracle Exadata / Supercluster Quarterly patching activates.
• Experience in implementing high Availability using Oracle RAC & Veritas Cluster server (VCS)
• Experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).
• Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
• Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.
• Extensive Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Proficient in INDEX REBUILDING and INDEX TUNING.
• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
• Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, Ocrconfig, Cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.
• Worked effectively on database Server Tuning, Application Tuning, and Database Security.
• Well experienced in managing data files, redo logs, rollback segments, stored procedures, functions, packages and Triggers.
• Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views
• Experience in working different storage technologies (SAN/NAS, ASM, ACFS, and Oracle ZFS 7320, 7420).
• Experience in Load and Performance testing of the database servers and application servers, analysis and documentation of results.
• Proficient in maintaining Data Integrity, Profiles, Resources, Password Security, Users, Privileges, and Roles.
• Working knowledge of My-SQL and SQL Server.
• Strong skills in SQL* PLUS, PL/SQL, UNIX Shell scripts (Ksh and bash).
• Responsible for monitoring and tuning the performance of queries and instances of production and stage databases using oracle features 10046 event trace files, hints, stored outlines etc.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually. Possessing excellent developmental and analytical skills.
• Utilized oracle business intelligence Enterprise Edition (OBIEE) to support the justice officer of the chief financial officer (OCFS) financial analysts to improve the process of reconciliation and verification of financial reports.
• Resolve connection issues for OBIEE with RAC Configuration and worked with SAP basic for BR tools, cloning of DB.
• Experience in upgrading Oracle database from 9.2.0.6 to 10gR2 and 11g.
• Installed and configured OBIEE, Discoverer 11g/10g with Load Balancing.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• SQL Server 2014, 2012, 2008R2, 2008, 2005 and 2000.
• Extensive knowledge of VPC architecture, EC2 formation, IAM management, S3, CloudWatch, Elastic IPs and managing securing groups on AWS.
• Experience in the design and implementation of Continuous Integration
• Continuous Delivery, Continuous Deployment (CI/CD), DevOps tool chain and DevOps processes for agile projects.
• Effective combination of System, Backup & Restore, Storage Administration Automating, configuring and deploying instances on AWS cloud Environment and Data centers.
• Design AWS formation templates to create VPC architecture, EC2s, Subnets and NATS to meet high availability application and security parameters across multiple AZs.
• Manage migration of on-prem servers to AWS by creating golden images for upload and deployment.
• Worked within the Cloud for integration processes.
• Performed DevOps for Linux Mac and Windows platforms.
• Focused on automation and integration.
• Monitored developed applications and fixed bugs.
• Wrote code and designed continual updates.
• Completed load and performance testing of extremely complex systems.
• Experienced with Interpreted Languages including Perl and Python.
• Facility with development methodologies including Agile.
• Excellent configuration management using Puppet Chef and Ansible.
• Extremely knowledgeable about CI/CIT/CID integration.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, 11gR2, 10gR2, 10gR1, Oracle 9i.

Oracle Tools & Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, STATSPACK, AWR, ASH ADDM, OEM, ODM, CELCLI, DCLI.

O/S: Linux, SunOS, IBM-AIX, HP-UX, Windows 2000/XP.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ORADEBUG

Automation/Build Tools: JENKINS,CHEF,ANSIBLE

Cloud Technologies: AWS(EC2,S3,Cloud Watch,RDS,ElastiCache,IAM)

Scripting Languages: PYTHON,UNIX SHELL

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. Oracle database Administrator with Cloud devops engineer

Responsibilities:

• Implementing and Upgrade advanced features of Oracle 12C such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Monitoring & Troubleshooting Oracle error logs, Various Scheduled DBA Server Agent jobs, Maintenance plans.
• Setup and maintain all database backups for all production Oracle servers. This includes using native Rman backup.
• Have good experience in administering ASM disk Groups.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Responsible for all regular Database administrative activities.
• Hands on experience in installing and administering Oracle WebLogic server (10.3.6).
• Implemented Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Implemented Golden Gate Change-Synchronization and Initial-load replication processes.
• Responsible for choosing Capture and Apply methods in Oracle Golden Gate Replication.
• Responsible for creating Processes groups in GoldenGate Replication.
• Experience in installing Trigger based DDL capture.
• Expertise Configuring the Bidirectional replication using GoldenGate
• Upgrading the database using GoldenGate zero down time migration.
• Building test strategies, backup & recovery models for Oracle. Refreshing test databases.
• Responsible for the day-to-day user requests and troubleshooting the database related problems.
• Implemented partitioning and materialized views for Oracle 10g and 11g Databases.
• Responsible for Online/Offline database backups and managing Database recovery with RMAN.
• Worked with Oracle Support during ORA-600 and ORA-7445 issues.
• Wrote scripts to improve the performance of importing indexes.
• Cloning of database for development and test environments.
• Estimate SAN storage need for replication across multiple sites.
• Implement new table partitioning technique using virtual columns.
• Support Performance testing team during weekend tests.
• Control user access and monitor space consumption.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster Recovery and Planning.
• Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Develop test and tune database code and information.
• Design and maintain Sql scrips.
• Installation and configuration of Oracle Enterprise Manager Cloud control 12c on RHEL.
• Migrating/upgrading the database from 11g to 12c in different operating system.
• AWS POC responsible for creating and managing VPC, AIM users, EC2 instances, EBS, S3 and RDS resources.
• Manage multiple AWS accounts with multiple VPCs for both production and non-production where primary objectives are automation, build out, integration and cost control.
• Create and manage S3 buckets and policies for storage and backup purposes.
• Design roles and groups for users and resources using IAM.
• Implement EC2 backup strategies by creating EBS Snapshots and attaching the volumes to EC2s when needed.
• Discusses technical and design issues with other developers, managers, users or customers whenever necessary to achieve best solution
• Familiarity with Tornado, Robot test framework, Continuous Integration environment (Jenkins), SDN, network switches/routers and DevOps a plus
• Mentors and assists activities of junior developers
• Help recruit and grow development talent
• Implement or leads the implementation of complex solutions with minimal technical debt. Develop solutions that are easy to deploy, maintain, and are bug free
• Participating fully in the development process through the entire software lifecycle
• Participating fully in Agile software development process
• Delivered Solutions to improve Cloud architecture, deployment for AWS private and public Cloud.
• Managed multiple AWS accounts with multiple VPC's for both Production and non-prod where primary objectives included automation,build out, integration and cost control.
• Worked on automation and continuous integration processes with Jenkins and chef.
• Bootstrapping instances using Chef and integrating with auto scalling.
• Created new Chef Cookbooks and updated existing ones to automate deployments.
• Managing AWS infrastructure with automation and configuration management tools such as chef.
• Automated application packaging and deployments though Chef.
• Automated Weekly releases with ANT/Maven scipting for complilling java coding,Debugging and placing Builds into Maven Repositiory.

Environment: Sun Spars 5.9, IBM - AIX, Linux, RMAN, Shareplex, Golden Gate, Toad, Expdp/Impdp, Oracle 10.2.0.4, 11gR2, GoldenGate, Shell scripting, AWS(Ec2,S3,RDS, VPC, IAM),Python,Jenkins,Anisble,Chef.

Confidential, Boulder, Colorodo

Oracle Database Administrator with Devops engineer

Responsibilities:

• Gathered the business requirements by interacting with the business users for the Points System.
• Worked on Amazon Web Services (AWS).
• 24/7 on-call production database support.
• Installation and Configurations of Oracle 12c, 11g, 10g.
• Installed Oracle 12c, 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Applied CPU patches.
• Migration of the database from Sun Solaris to IBM AIX, Windows to Linux.
• Expertise in recovering the database. Performed complete and incomplete database recovery.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
• Automated the nightly RMAN backups.
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• PL/SQL Programming.
• Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Experience in taking backups with RMAN in both Catalog/ No catalog modes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Attended training sessions on Mongo db, Oracle 12c.
• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• RMAN Incremental backups.
• Logical and Physical Database Design.
• Partitioning of the tables for better performance and manageability.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Cloning databases using scripts as well as RMAN.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
• Golden Gate installation and configuration.
• Replication using Golden Gate. (schema level).
• Worked on Exadata environment.
• The work will involve the development of workflows triggered by events from other systems
• Develop easy to use documentation for the frameworks and tools developed for adaption by other teams
• Iterate rapidly and work collaboratively with product owners, developers, and other members of the development team
• Work closely with Teams across the BU to create comprehensive test tools and automation frameworks
• Works with other team members, including DBA's, Other ETL developers, Technical Architects, QA, Business Analysts & Project Managers
• Work directly with project owners across the business and plan, manage and execute key projects
• Follow and improve established processes for software development life cycle with an agile approach to delivery software
• Automated the release pipeling to acheive zero touch deployments using Jenkins,Svs,Nexus and Noilo.
• Coordinate/assist developers with establishing and applying appropriate branching,Labeling/ Naming conventions using Subversion(SVN) source control.
• Used Maven dependency management system to deploy snapshot and release arifacts to Nexus to share artifacts access projects and environmnets.
• Design AWS Cloud Formation templates to create custom sized VPC,subnets, Nat to ensure successful deployment of Web applications and database templates.

Environment: Oracle12c, Oracle 11g RAC, Oracle 10g RAC, Mongodb, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD, SQL Developer, SQL*Loader, ERWIN, Data Pump, AWS(Ec2,S3,RDS, VPC, IAM),Python,Jenkins,Anisble,Chef

Confidential

Oracle Database Administrator

Responsibilities:

• Migrated single instance database to multiple instance databases using exp/imp data pump.
• Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Expert in Installation, Configuration and Maintenance of Oracle Standby Data Guard.
• Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.
• Oracle 9i/10g/11g/12c RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management (ASM) and Configuration and Tuning.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Implementing 10g Data guard with one physical database.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases).
• Setup RMAN solutions for all Oracle Databases -- created Rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purpose.
• Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard)
• Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.
• Responsible for the installation, configuration and overall up from 10g/11gr1 to 11gr2 (10.2.0.2 to 11.2.0.2)
• Databases migrated to RAC for improved resiliency and performance.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Created indexes to facilitate easy user interface implementation and tuning.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Environment: Oracle Applications R12.1.3, OBIEE 11g, OBIA 7.9.6.4., Informatica 9.5, Oracle 11g, Toad, UNIX, Windows.

Confidential

Oracle Database Administrator

Responsibilities:

• Involved in administering more than 150+ Production databases of size ranging from 200GB to 30 TB.
• Involved in configuring two node RAC on 11gR1, Oracle cluster ware on Red hat Linux AS 5.
• Added node for the existing two nodes RAC.
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and Standalone database
• Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC).
• Experience in setting up Oracle ASM storage for Oracle RAC databases.
• Performed database replication through Streams.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Responsible for the smooth functioning of all ecommerce activities of the organization.
• Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files

Environment: RAC on Linux 4 & Oracle 10g, 11gR2, RHEL 4u8, 5U8, OEM, Streams, Data guard, Netapp NFS, Sql loader, RMAN, DataPump.

Confidential

Database Administrator

Responsibilities:

• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Installed and setup 10g Oracle Enterprise Manager Grid Control (10.2.0.3) and Mass Agent Deployment on several hosts.
• Installed Oracle Data guard for Oracle Disaster recovery, High Availability and data protection.
• Manage multiple MySQL databases used for storing records, payment, and customer relations data.
• Data Modeling, Database Design and Creation using ER-Win.
• Experience in setting up Oracle ASM storage for Oracle RAC databases.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Log Miner, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Performed administrative maintenance, monitoring both Oracle and MS SQL Server database systems in a global 24x7 operational environment.
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
• Installed and Configured Oracle 10g databases on Linux.
• Performed automated backups and scheduling using Perl scripting.
• Involved in designing logical & and physical data models using power designer.
• Implemented Oracle Database 10g two node Real Application Cluster (RAC) on a Linux system
• Installed and configured Oracle Enterprise Manager 10g Grid Control.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Environment: RAC on Linux 4 & Oracle 8.1.7, 9.2.0, 10.2.0.4, 11.1.0.6, Windows 2003, HP-UX 11.11, Sun OS 5.9, EXPDP, IMPDP, SQL*Loader, Hp Glance.