PROFESSIONAL SUMMARY:

• Around 8+ years of IT experience withOracle,RAC, ASM, RMAN, Golden Gate,OEM,AWS cloud,Mysql, Sql server, Agile process, Waterfall model,in Health, Utilities, Geomatica, Government and Manufacturing domains
• Experienced in design, development, ER Modeling, data modeling, Physical/logical design,configuration,performance tuning,backup/recovery, database security,Disaster Recovery, documentation in Oracle Development with providing database administrative support for Production, Development and Staging environments.
• Installing, configuring, patching & administration of Oracle software versions 10g, 11g, 12c and involved in Oracle 12c OEM Installation, patch management and administration.
• Experience in scheduling full database backup jobs, archive jobs through OEM and managing databases through OEM (10g, 11g,12c) and up gradation based on requirement.
• Extensive experience in Oracle Golden Gate replication, database server configuration, installation and troubleshooting Golden Gate extract and replicate issues
• Configuration of Standby database/Data guard for RAC databases, monitoring RAC instances and Creating/Managing services in RAC
• Supporting projects using Expdp/Impdp, Data Pump, RMAN, cold / hot backupsdatabase refresh schema refreshes, table refreshes and AWS.
• Scheduled full database backup jobs, archive jobs through OEM and Implemented RMAN backups from Physical Standby and Setting up, managing oracle physical standby using Data guard Switchover and Failover.
• Supporting monthly change activities related to production database and generating AWR/ ADDM reports after every Change Activity to identify high availability issues and perform tuning on SQL’s identified in the reports to maintain database operations
• Build new databases and clone existing databases for specific functions, including disaster recovery, reporting, critical issue testing and resolution and performance testing.
• Trouble shooting performance issues reported by the application Team usingstats pack reports to effectively tune SQL statements.
• Automation of backup jobs using shell scripting.
• Experienced in creating/managing and administering the database objects like schemas, tables, indexes, synonyms, sequences, materialized views, views, Indexes etcand migration of data files from File system to ASM
• Experienced in implementing 12c new features like table partitions, gather stats, restoring data files online using Rman, online migration of data files, table partitions, Invisible columns etc.
• Implemented database level security for auditing database user activity to ensure all actions are recorded and users are accountable
• Installation of ARCGIS and ARCSDE version 9.2 for Geomatica data and Provided technical support at various aspects of GIS data
• Experience in migration of Oracle database/Objects to Sq server using SSMA.
• Installing SQL server and managing backups using JOB Scheduler,If databases or transaction logs are larger than necessary shrink those files to free up disk space
• Good working experience on User Account Management, Backups, recovery, restore, log shipping and mirroring of SQL SERVER.
• Responsible for processing the E - mails/ alerts and deployment of scripts to stage/development environments based on requirement.
• Monitoring various database activities like number of users, memory usage, alert log files, trace files and archive log files in MySQL, SQL Server and Oracle.
• Good working experience on Binary Logs, General Query Logs, and Error logs.
• Having Knowledge on Export-Import, Data Transformation for loading the data of MYSQL and SQL SERVER.
• Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.
• Performing DB health checkups like account unlock, password reset etc.
• Monitoring backup jobs and scheduling the sameand resolving Blocking/deadlock issues, Performance issues.
• Having good working experience security management, backup/recovery in MySQL,SQL Server.
• Plan and coordinate database activities for scheduled monthly maintenance.
• Documentation and research of new technologies that are related to current and future team goals.
• Involved in migrating databases from on premises to cloud with experience in planning, designing and implementing DBaas.
• Having Good Knowledge on Big data and Hadoop.
• Excellent Team Player to coordinate with team members for data validation, DBA tasks and new technologies in order to manage the database portion of application releases.
• Strong Analytical and capable of handling multiple projects and deadlines with Problem Solving skills, Multi-Tasking abilities with proven experience

TECHNICAL SKILLS:

Database: Oracle 9i/10g, 11g, 12c, 12c OEM, SQL Server 2005&2008,2012,2014, Mysql5.0.,Postgres SQL

Data Modeling Tools: Toad data Modeler, MySQL Workbench5.0, Erwin, Navicat, Ms Visio

Database Tools: Golden Gate, Toad for Oracle and MySQL, Sql*plus, Oracle Sql Developer, Navicat for MySQL, SQL Studio, SQL Query Editor, MySQL Query Browser,MySQL, MySQL Administration, Sql Yog, Remedy

Database Migration Tools: SQL Ways 3.5/5.6, MySQL Migration toolkit, Spectral Core.

Languages: PL/SQL, SQL, UNIX Shell Scripting, HTML

Others: RAC,ASM,RMAN, ASMCMD,ASMDA,DG, AWS, Ansible, RDS,DevOps,DBaas,SSIS,SSAS,SSRS

Operating Systems: Windows 2000/2003/XP/NT/Vista, UNIX, LINUX,SOLARIS

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

Sr. Database Administrator

Responsibilities:

• Upgrading oracle databases from 11g to 12c and implementing 12c databases for QA/test/dev environments, and applying one off patches and patch set updates as per Oracle upgrade matrix
• Ensure all daily logical and physical backups are successful, including full exports, schema exports, and RMAN hot/cold backups
• Provided Support for Critical Databases and enhancing the database monitoring process and troubleshooting issues during upgrade, applying patches to fix issues in ORACLE databases.
• Work with developers in needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.
• Dealing with Proactive and Reactive Tuning techniques including SQL load balancing and assistance using Query Optimizers and Tuning Advisor.
• Design and implement processes for database backups, restores and recovery models using RMAN
• Working on data modeling by maintaining data migrations, data accuracy, data transformation and data consistency with data modeling tools.
• Plan, coordinate, and administer database systems, including base definition, structure, documentation, requirements, operational guidelines and protection
• Monitoring various database activities like number of users, memory usage, alert log files, trace files and archive log files.
• Database lock, space management, export and import of the database, performance tuning at DB and apps Level
• Creation and modification of Tables, views, Sequences, Constraints, indexes, synonym, procedures, functions, triggers and events.
• Working experience with Golden gate and its components.
• Installation and configuration of Oracle databases (single instance) and configuration of RAC instances in oracle 11g and Converting single instance databases to RAC databases.
• Working on complex queries for SQL Query optimization, code and lockdown situations.
• Developing active standby and snapshot standby databases for 12c test database environments through the application of Data guard broker.
• Involved in planning, migrating the on premises database to AWS cloud.
• Using shell scripts for scheduling the backup jobs and running queries.
• Daily monitoring of Database and System resources, including disk space, table space and extent growth, memory usage, and overall database performance
• Managing oracle physical standby using Datagurd Switchover and Failover in Physical Standby.
• Quarterly patching of Oracle database and supporting databases on AWS.

Environment: Oracle 10g,11g,12c,13c OEM,Sql Server,SSAS,SSIS,SSRS, DevOps, Postgre SQL, Enterprise DB,Shell scripting, T-SQL, Golden Gate, Oracle Sql Developer,AWS,RDS, ODBC, ER/Studio, SQL profiler, Linux

Confidential, Bloomfield, CT

Sr. DBA

Responsibilities:

• Designed and created Database objects tables, Keys, Indexes, Views, Materialized view as per requirement
• Provided Level 4 Production Support and responsible for processing all the E-mails and monitoring all the alerts
• Provided Oracle database administrative support for Production, Development and Staging databases
• Managed Daily Backups of Production database and using different databases based on requirement.
• Configured Standby database/ Datagurd for RAC databases
• Supported monthly Change activities related to Production database and generating AWR and ADDM reports after every change activity and perform tuning on SQL’s identified in the reports.
• Implemented database refresh using RMAN and full EXPORT/IMPORT
• Scheduled full database backup jobs and archive jobs through OEM
• Create and Manage Table spaces and Data files as needed in oracle and implemented database level security using Roles and privileges in Sql server and ORACLE.
• Performed database refreshes (Using Hot & Cold backups, RMAN), schema refreshes, table refreshes
• Upgraded Oracle RAC Database s to 11.2.0.3 from 10g and Migration of data files from File system to ASM
• Participate in cross-training and knowledge transfer with team members.
• Troubleshoot performance issues reported by the Application Team
• Installed Oracle 12c database on test servers
• Involved on Query Optimization, procedures optimization, Indexes creation and tuning of Server Parameters in SQL SERVER and ORACLE.

Environment: Oracle 10g/11g, PL/SQL Developer, Sql Server, DevOps, Enterprise DB Golden Gate, SQL*Plus, TOAD 12.10, SQL*Loader, TFS, Windows Server2008/Windows 7, UNIX, Erwin 9.0

Confidential, Rancho Cucamonga, CA

Sr. DBA

Responsibilities:

• Attend business meetings and understand new business requirements
• Building technical specification requirements that contains all the comprehensive project requirements and scope
• Generated DDL scripts and created and modified database objects like Tables, Views, Sequences, Functions, Procedures, Indexes, Packages, Records and Collections using TOAD
• Involved in performance tuning using Oracle Hints and Explain Plan for Views and Queries
• Created relevant staging tables to load data, identified the business validation rules. Created SQL Loader scripts using UNIX shell scripting and PL/SQL
• Taking incremental backups of the database with block change tracking in RMAN
• Tuned sql queries based on recommendations from OEM and with the help of AWR reports
• Monitored the Applications and database using OEM
• Involved in the Logical & Physical Data Modeling of the application
• Used SQL* Loader and UTL FILE Packages for data conversions and interfaces
• Expertise in handling System Analysis and Business Analysis related issues when the application is in earlier stages
• Involved in client interaction, handling change requests and implementing the application on the client side
• Coordinated with the business analysts for requirements analysis
• Designed and created Database tables, Keys, Indexes, Views, Materialized view as per requirement
• Export and Import database backups using Exp/Imp and Expdp/Impdp utilities
• Create and maintain user id's in all non-production environments in SQL SERVER and ORACLE.
• Assist developers with DDL/DML requests and managed databases through OEM(10g,11g)
• Troubleshoot database issues and Involved on partitions and User Account Management.
• Database design responsibility included the conceptual data model design using ER diagrams, logical database design and physical implementation of the database.
• Identification and implementing business rules(constraints, triggers etc.) and views.
• Handled DBA activities like Server installation, database creations, user creation, Backups and Restoring of Databases, Scheduling, Setting of Sql Modes etc in SQL SERVER.
• Involved in Log shipping, Mirroring and Replication Activities.
• Prepared the necessary documentation and design specifications of project.
• Added provision to add or modify users and their privileges.
• Worked with Team and Users in building database.
• Work on multiple projects simultaneously, which span multiple applications

Environment: Visual Studio.Net 2010, ESRI ArcGIS, Visual Source Safe, Sql Server 2008,Postgre SQL, Oracle10g, 11g, Linux, Solaris, UNIX.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured oracle database 11g on Linux server and SQL Server on windows.
• Created Tables, Views, Materialized views, Constraints for ORACLE and SQL SERVER databases.
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes to improve performance of application
• Involved in creating Test Plans and Unit testing
• Performed Database Cloning and refresh on to Test environment
• Backup and Recovery using Recovery Manage
• Performed logical backups using Exp/Expdp utilities and restore specific objects and schemas using Imp/Impdp utilities
• Password file was created for network authentication of the administrator
• Creation of databases and configuration of listener and tns
• Creation of users and assigning roles and privileges in SQL SERVER and ORACLE
• Generating AWR Report for database performance Health Check
• Performed Index Rebuilding to enhance the performance in SQL SERVER and ORACLE.
• Creation of table spaces, Adding or resizing data files and handling Space related issues of Tablespaces
• Managed Control files, online redo logs, Archive redo logs and configured pfile, spfile and parameter management
• Designed and developed Database objects like Tables, Indexes, Sequences, Views and administer/ manage Oracle Users, roles, and privileges in SQL SERVER and ORACLE
• Configured RMAN for backup of the different databases and Cloning ofDatabases using RMAN
• Used AWR different levels for database statistic collection, ASH and ADDM
• Reports for database performance related troubleshooting
• User creation and providing necessary Roles, Privileges and quota as per the requirement
• Configured RMAN in catalog mode and performing daily, weekly and monthly backups for production Database.

Environment: Java, Oracle 10gR2, Linux, Solaris,Dot Net, SQL SERVER,Win 2000 Professional, Win Server 2003.

Confidential

DBA/ Developer

Responsibilities:

• Created and managed physical and logical objects of the database
• Moving data between databases using utilities like Export/Import
• Cloning Activity for Databases from Production to Testing Environment as and when required
• Index Rebuilding for performance of the database when required
• Configured Listener and tnsnames to communicate between client and server
• Password file was created for network authentication of the administrator
• Worked with developers to tune sql queries on DDL/DML.
• Creating table spaces and monitoring their growth and Resize or add more data files to database or table spaces for space related issues
• Created Users, Roles, Profiles and granted privileges and permissions to appropriate users
• Created and maintained database entities included Table spaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers
• Design, develop and implementation of backup and restoration procedures
• Reorganizing the Table spaces on scheduled basis on blade servers
• Worked with sql server 2008 and MySQL 5.0 to switch data between the databases.
• Performed backups, restores, and review logs for SQL Server environment
• Implemented data security and groups, roles, privileges, authentication for SQL SERVER and ORACLE.
• Created jobs using maintenance plans for Full, Differential and Transactional Log backups for SQL SERVER.
• Migration of Oracle database to sql server using SSMA.
• Build and design automated jobs for indexes, backups, daily maintenance and task scheduling

Environment: Java, Oracle 10gR2,SQL server 2005/2008,Mysql 5.0, Linux, Dot Net, Tomcat web server.