SUMMARY

• SDLC: 10+ years of IT experience in Database Administration including analysis, design, development, maintenance, testing, documentation, implementation and user training/support. Configuration and maintenance of oracle 12c,11g,10g,9i databases and applying patches as required under Linux, HP UX, Sun Solaris, AIX and Windows platforms
• Full scale Golden Gate implementation experience across different databases such as Oracle, Sybase and MS Sql Server. Setup GoldenGate replication to replicate data across different platforms.
• Worked on multiple 10 to 11g data warehouse upgrades using golden gate
• Re - architected ETL jobs using GoldenGate replication for faster movement of data across enterprise environment and data integration.
• Two implementation of Oracle 12c multi-tenant database. One was a Proof-of-concept and the other project was a database upgrade from version 11. .1.0.1 version. This database upgrade was a out-of-place upgrade using oracle golden gate for zero down time upgrade. Worked on detailed documentation of Oracle 12c database software install. Created response files for silent installs of 12c software. Setup and administration of Multi-tenant database using database consolve express edition. Worked on attaching and detaching PDB and CDB databases.
• Two implementations of Oracle 12c Enterprise Manager Grid Control on Red Hat Linux and Solaris platforms.
• Worked on Oracle 12c database install, 11g to 12c database upgrade proof of concept on Linux and Windows platforms.
• Thorough knowledge of Software Development Life Cycle (SDLC) with respect to database design, implementation and maintenance
• Managed Database Structures, Converted Logical data to Physical data, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges and Database Auditing
• Worked extensively on Oracle 11g/10g databases, performed installation and configuration of Automatic Storage Management (ASM) with EMC DMX Storage and Flash Recovery Area (FRA)
• Proficient with Real Application Testing (RAT) by capturing production work load and replaying it on a test system
• Worked extensively on Very Large Databases (VLDB) ranging from 200 GB to 8 TB
• Expert in Partitioning Administration: creating, managing, pruning and merging the partitioned tables
• Planning and scheduling Backups using RMAN (hot, cold and incremental backups) and export/import, datapump utilities
• Expertise working with Web-Application development teams on J2EE platforms, Installed and configured JDBC and ODBC.
• Worked extensively with Oracle High Availability (HA) technologies like Real Application Clusters (RAC), Data Guard, Flashback and RMAN
• Worked extensively with Data Guard in creating physical and logical standby databases
• Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, STATSPACK, SQL TRACE
• Experience in performing database upgrades and applying latest critical patch updates as well as patch set updates
• Experience in Unix Shell and Perl Scripting for automating the DBA tasks
• Knowledge of Java, MySQL, multi-master replication and Amazon Webservices.
• Knowledge of Hadoop, Cassandra, MongoDB and Map/Reduce concepts.

PROFESSIONAL EXPERIENCE

Confidential, St Louis, MO

Database Admin (Oracle/SQL Server)

Responsibilities:

• Setup, administer and troubleshoot golden gate replication issues across database environment.
• Worked in operation management team to handle day-to-day database issues, worked in on-shore/offshore model and ensured 24*7 availability.
• On-call rotation every 2 weeks and handling production issues.
• Worked extensively on performance tuning and partitioning.
• Worked on SQL Server 2008 and SQL Server 2012 databases as Operations DBA.

Confidential

Database Architect/Application DBA

Responsibilities:

• Setup and configuration of oracle golden gate replication (bidirectional) with conflict detection and resolution. Strong replication experience.
• Worked as team lead for a team of 3 DBA’s in Confidential data architecture team.
• Handled Development and production support incidents. Worked with application teams to handle failover and switchover scenarios and handled any database and replication issues occurring during this process.
• Worked on multiple applications (7 different applications) Confidential the same time. Ability to handle OLTP, ODS and OLAP database.
• Two implementation of Oracle 12c multi-tenant database. One was a Proof-of-concept and the other project was a database upgrade from version 11. .1.0.1 version. This database upgrade was a out-of-place upgrade using oracle golden gate for zero down time upgrade. Worked on detailed documentation of Oracle 12c database software install. Created response files for silent installs of 12c software. Setup and administration of Multi-tenant database using database consolve express edition. Worked on attaching and detaching PDB and CDB databases.
• Ability to resolve performance issues, good working knowledge of partitioning.
• Worked on database migration on traditional hardware onto Exadata(X4/X3) machines, used EHCC to compress warehouse data.
• Hands on knowledge of release management, code deployment, production incident triage and ticketing systems.
• Ability to handle Sql Server, Postgressql and Sybase databases apart from any version of oracle database.

Confidential

Data Architect

Responsibilities:

• Performed the role of Data Architect/ Database Administrator in implementing Golden-Gate replication.
• Worked on installation and setup of Oracle Golden-Gate replication(Version 11) to replicate data across the enterprise environment.
• Setup Goldengate replication to replicate data across different platforms.
• Worked on multiple 10 to 11g zero-downtime upgrades using golden gate replication

Confidential, Winston-Salem, NC

Database Administrator

Responsibilities:

• Worked on administration, performance tuning backup and recovery configuration of Oracle 11gR2 databases. Implemented best practices to be practiced for oracle databases.
• Worked on migrating data and application functionality from Oracle 11gR2 into Hadoop Cluster (Hortonworks). Used Sqoop jobs to load data into Hadoop.
• Worked on setting up and troubleshooting of 10-node hadoop cluster. Worked on issues related to Name-node. Performed user administration and job monitoring in Hadoop.
• Administered SQL Server databases including creating databases, code deployment, performance tuning and code troubleshooting in sql server. Used Idera SQL Safe and Diagnostic manager for Sql Server database administration. Worked on loading data from AWS based SQL server and postgresql databases into a Datamart. Worked on SSRS reporting and resolved bad data issues.
• Worked on MSSQL server 2008 to AWS-RDS (Postgresql) database migration
• Provided on-call database support
• Experience supporting reporting and Analytics teams to get their data in time.
• Worked on MySQL 5.2 database migration into Hadoop cluster using sqoop jobs. Performance tuning and day to day database administration of Mysql database.
• Worked on data migration from on-site database to AWS-RDS instances.
• Worked with Devops to modify, trouble shoot and tune databases present in AWS-RDS.
• Gained knowledge of RIAK high availability clusters and Couchbase database.

Confidential, Madison, WI

Database Administrator

Responsibilities:

• Installation, configuration and maintenance of Oracle RAC and MSSQL-clustered databases, this includes security setup/maintenance, Data Encryption (TDE), auditing and backup/recovery.
• Working on Oracle Database Appliance (ODA) to build a 2-node RAC cluster with Disaster Recovery (Data Guard with logical standby). Provide guidance in implementing data security using transparent data encryption (TDE) and Virtual private database (VPD) techniques.
• Implement Exadata hybrid columnar compression (EHCC) on Exadata machine hosting 15 TB data warehouse and reduced the amount of storage required by 50%. Worked on patching exadata machine using Exadata deployment assistant.
• Worked on cost-benefit analysis between Oracle Data Appliance versus Oracle Exadata platform.
• Full scale implementation of Golden Gate between Oracle 10/11g and Sybase databases.
• Enterprise wide Oracle 12c Enterprise Manager Implementation.
• Oracle 12c database install on Linux 6.0/Windows. Oracle 11g to 12c database upgrade POC.
• Performance tuning using AWR reports and various other database tools and utilities.
• Enhancements to Materialized views for faster generation of Cognos and OBIEE reports.
• Collaborate with multiple development teams for database design practices and normalization concepts. Troubleshooting and performance monitoring and tuning of Oracle and SQL server databases. 24*7 on-call production support.
• Work across platforms Confidential Server, database and application server level to trouble shoot issues.
• Provide cross platform development guidance to developers.
• Code troubleshooting of SQL and PL/SQL, performance tuning and partitioning strategies.
• Interact with SAP, Oracle, IBM, and Microsoft regarding licensing and technical issues.
• Shell scripting to automate repetitive tasks and alerting mechanisms.
• Work with third party vendors for application upgrades and patching.

Confidential, Boston, MA

Lead Oracle DBA

Responsibilities:

• Responsible for planning, building, implementing, administering, and maintaining ORACLE databases in the Confidential Investment Management technology team.
• Built and successfully integrated complex, Multi-Terabyte OLTP(9TB) and Data Warehousing ORACLE databases which was used as part of PaaS architecture (Platform as a service).
• Ensure optimal database performance through exhaustive pre-production testing and ongoing real-time monitoring. Troubleshoots issues to resolution (AWR, ADDM, ASH, Sql Monitoring).
• Worked on Oracle RAC, Golden gate and Exadata machines.
• Worked with internal and external customers to plan, evaluate, and design databases in accordance with team and company standards.
• Provide tasks and timelines to support the creation of project plans with appropriate updates for those tasks throughout the project lifecycle
• Participate in data model design, review the database model and assist in the implementation of data models. Do code reviews through crucible (code review tool) to make sure that the code going into production does not have any cross impact or performance issues.
• Extensive experience with Oracle Golden Gate replication, Confidential Sybase replication and AS400/DB2 platform.
• Extensive Investment banking experience with good domain knowledge.
• Writing and maintaining SQL and PL/SQL scripts, complex code deployments
• Implemting partitioning strategies.
• Provides tasks and timelines to support the creation of project plans with appropriate updates for those tasks throughout the project lifecycle.
• Implement data security standards through Virtual Private Database setup.
• 10g to 11g and 9i to 11g database migrations/upgrades.
• Worked under high pressure 24x7 zero fault tolerance environments. On call 24x7 production support experience.
• Interact with oracle through Metalink for ORA-600 Issues.
• Implemented Database virtualization technology in Confidential which can deliver production quality data on the fly to application teams. This technology has proved to be very useful for Unit and Integration testing activities or to resolve production data issues.
• Setup Active data guard with active-active configuration and perform database switchover during disaster recovery drill.
• Oracle Exadata- Currently we have migrated most of our production databases to Exadata
• Cloning and refreshing non-production environments through RMAN, Datapump and export/import
• Agile Methodology—Daily standups
• Coordinate meetings and drive projects towards project deadlines.

Confidential, Columbus, Ohio

Lead Oracle DBA

Responsibilities:

• Installation & Configuration of Oracle 11g, 10g on Linux (RHEL 3, 4). Upgraded databases to 11g (dev).
• Worked on creating real application clusters (Oracle RAC, 3 Node, Size 17T)
• Extensive experience working with Oracle RAC in Installation, configuration, performance tuning and trouble shooting of RAC systems.
• Implemented various replication solutions using Oracle Golden Gate and Oracle Streams.
• Implementation of RMAN backups, Extensive experience in working with scripts
• Configured ORACLE DATAGUARD, Implementation of physical standby database and Active dataguard.
• Gather Oracle Database statistics - like Table space sizes, Data files sizes, etc.
• Planning Backup strategy for all instances. And Log Monitoring, Migrating database schemas.
• Recover Database from backup. Used Data Pump for bulk data migration.
• Improved Performance of database by tuning parameters like library cache, log buffer, missing & rebuilding indexes, buffer cache hit ratio, sorts, reparsing of SQL, free list contention .
• Performed RAC Installation over local file system. Voting & SRVM disk are located on RAW partitions and database is on ASM file system
• Experience using Explain plan, Tkprof, Events tracking, Auto trace and identifying the execution plan and tune queries, using indexes, hints etc
• Created symbolic links to access these Raw Partitions from the Oracle Database
• Responsible for database security and patching and Control and monitor user access
• Performed day to day database administration on existing databases and applying patches (OPATCH) and upgrades as needed,
• Installed, Configured and effectively used Oracle ASM, AWR, ASH, ADDM features
• Performed day to day database administration on existing databases and applying patches (OPATCH) and upgrades as needed,
• Participated as a member of the engineering teams for database-related tasks like optimizing the SQLs
• Maintained effective database performance monitoring procedures
• Control and monitor user access to databases and maintain database security
• Allocate storage and develop plans for future storage requirements.
• Maintain documentation of systems and standard operating policies and procedures.
• Resolve development and QA database requests

Confidential, Seattle, WA

Oracle DBA/ Developer

Responsibilities:

• Installation, upgrade and maintenance of oracle 10g/11gR2.
• Customizing the oracle database to data warehouse environment.
• Installed Oracle 10g Enterprise Manager (OEM/Grid Control) for diagnosing and monitoring performance related problems and configured with Applications servers on databases.
• Performing star transformations Confidential the database level. Also work on Informatica transformations.
• Extensively worked on performance tuning Confidential both database and SQL level.
• Data Migration as part of enterprise data warehouse project.
• Worked with import/export, export data pump/import data pump and SQL Loader.
• Writing PL/SQL Procedures and functions. Writing shell scripts to automate the data loading.
• Supporting Informatica and OBIEE application and other SLA requirements.
• Improved the performance of database by creating and managing database objects such as tables, Indexes, Partition tables, Index Organized tables, material views and views.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and tuning.
• Install, Upgrade and configure Oracle database for various 32-bit and 64-bit platforms like HP-UX, Solaris - Sun SPARC & Intel, MS Windows 2000.
• Used shell scripting for automation of job scripts, for Startup and Shutdown, Health Check of Databases, Analyzing tables and Rebuilding Indexes.
• Implemented Range, List Partitions, Hash Sub Partitions, creating and refreshing materialized views.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects and also did the patch management for oracle upgrade

Confidential, New York, NY

Oracle DBA

Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 on Intel and HP boxes.
• Configured Streams to capture propagate; apply changes in multiple databases.
• Configured, administered and monitored a Streams environment using various tools like OEM console.
• Successfully migrated databases from Intel Boxes (Windows 2000, Windows 2003 servers) running oracle 9i over HP-UX Itanium boxes running oracle 10g and non-ASM instance to ASM instance.
• Setup, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Data Migration as part of enterprise data warehouse project.
• Personally responsible for performance, backup and recovery related issues of over 56 databases with 11 production, 23 development and 22 QA databases.
• Used shell scripting for automation of job scripts, for Startup and Shutdown, Health Check of Databases, Analyzing tables and Rebuilding Indexes.
• Data Modeling, Database design and creation using ER-win, Visio.
• Worked on import/export, export data pump/import data pump and SQL Loader.
• Installed and Implemented Backup and Recovery Procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and Configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Extensive Performance Tuning, Memory(SGA) Tuning, Net backup, EMC(Time finder and SRDF), RAW Devices
• UNIX shell scripting in csh, ksh to be controlled from Crontab
• Downsizing and defragmenting the Very Large Databases by export/ import, cloning those using RMAN duplicate features and then upgrading them Oracle 10g.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Used SQL Server for ecommerce applications.
• Load Balancing, Databases/Schemas/Table Re-Organization for faster performance using export/import & Move procedures. Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Storage Management Managing space, Table spaces, Segments and Extents, Rollback Segments and Data Dictionary
• Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing and performance tools in physical/logical databases.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Applications servers on databases.
• Designing the security and database access strategies using tools like ESM.
• Installation, upgrades and maintenance of oracle 10g/11gR2.
• Customizing the oracle database to data warehouse environment.
• Installed Oracle 10g Enterprise Manager (OEM/Grid Control) for diagnosing and monitoring performance related problems and configured with Applications servers on databases.
• Performing star transformations Confidential the database level.
• Extensively worked on performance tuning Confidential both database and SQL level.
• Data Migration as part of enterprise data warehouse project.
• Worked with import/export, export data pump/import data pump and SQL Loader.
• Writing PL/SQL Procedures and functions. Writing shell scripts to automate the data loading.
• Supporting Informatica and OBIEE application and other SLA requirements.
• Improved the performance of database by creating and managing database objects such as tables, Indexes, Partition tables, Index Organized tables, material views and views.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and tuning.
• Install, Upgrade and configure Oracle database for various 32-bit and 64-bit platforms like HP-UX, Solaris - Sun SPARC & Intel, MS Windows 2000.
• Used shell scripting for automation of job scripts, for Startup and Shutdown, Health Check of Databases, Analyzing tables and Rebuilding Indexes.
• Implemented Range, List Partitions, Hash Sub Partitions, creating and refreshing materialized views.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects and also did the patch management for oracle upgrade.

Confidential, Santa Clara CA

Oracle DBA

Responsibilities:

• Installation, configuration and tuning of Oracle 10g and 9i RAC on redhat-4, IBM-AIX 5.3
• Involved in Design and Implementation of Oracle 10g Dataguard both physical/logical standby databases in high availability mode.
• Supported bi-directional replication using oracle streams and designed the conflict resolution.
• Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Closely monitoring and administering log transport services and log apply services in physical/logical databases.
• Up gradation from Oracle 9.2.0.8 databases to Oracle 10.2.0.3
• Used shell scripting for RMAN and hot backup and recovery.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Implemented Backup using RMAN (Recovery Manager) as a media management layer.
• Have worked on building complex logical data models, reverse engineering and forward engineering using sophisticated modeling techniques and tools like Erwin and Visio.
• Improved the performance of database by creating and managing database objects such as tables, Indexes, Partition tables, Index Organized tables, material views and views.
• Performance tuning i.e. tuning RAC, applications, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/ Logical I/O and Memory usage.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Optimizing ETL procedures and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL Trace.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Consulting and advising with developers on the design of applications having complex database considerations, design custom database objects as required and recommended data access solutions that best fit the needs of the application.
• Used export/import for schema, table and database refresh.
• Implemented Range, List Partitions, Hash Sub Partitions, creating and refreshing materialized views.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects and also did the patch management for oracle upgrade.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and tuning.
• Have done database backup and recovery using(cold backup/Hot backup/ logical)