Sql Server Data

WHAT I’M LOOKING FOR

Looking to work in a challenging environment and ready to learn new technologies.

EXPERIENCE SUMMARY

Over 17 years of experience in Administrating Oracle, Microsoft SQL Server, MySQL and Production and Development Databases. Leading various enterprise projects, including data center move to Texas. Planning, identifying stakeholders, calling bi-weekly meetings, tracking the resources and progress of the projects, identifying bottlenecks to implement the projects on time.

Lead the datacenter automation project using Orchestrator to automatically switch data center from California to Texas. Managed a team of DBAs to support enterprise databases, setting standards, proactively monitoring database to identify any issue that may bring down database.

Lead storage migration of more than 80 Oracle production and development databases from 3par to pure storage. Planned and executed database migration of 12c and 11g data guard databases to pure storage.

Owning, tracking, assigning and resolving database related incidents and requests within SLAs, reviewing service related reports (e.g. database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with Database Architecture to come up with strategic solutions to recurring problems.

Extensive experience upgrading 11g databases to 12c. Installation, support and administration of all the versions of databases up to 12c with multi-tenant. Upgrade of database to 12c. Supported production databases 12c, 11g, 10g, 9i, 8i and 8.

Managed SQL Server and Oracle databases, used different database replication technologies, database backup/recovery technologies, database performance tuning. Supporting SQL and Oracle Servers using a SAN and Fiber Channel as a storage platform and running both in a physical and VMWare configuration.

Administered ODA, managing databases on ODA, adding Disk, Cloning vdisk, patching Databases in ODA. Moved Oracle 11g R2 RAC database to ODA using RMAN backup to ODA.

Designed MAA and Disaster Recovery Solutions for mission-critical production database servers. Designed and implemented Oracle RAC 11g Disaster Recover Solutions for D2000 systems.

Installed, implemented and supported 2- node architecture 11gr2 RAC mission-critical 24X7 production environment. Troubleshooted and resolved performance issues related to RAC databases. Tuning of interconnect. Tuning global cache directory. Re-mastering of the blocks for better performance. Monitoring of RAC specific waits in the databases and tuned the database for better performance.

Supported SDLC with release management. Extensively used Remedy and Jira as release management software to support release management. Passed level 1 ITIL certification for documentation management.

Architected GoldenGate data replication processes. Developed GoldenGate system macros, analyzed applications for GG suitability. Identified and remediated data synchronization issues. Provided expertise on Oracle Golden Gate and configured Golden Gate and troubleshoot the issues related to Golden Gate.

Experience in installation, implementation and configuration of Grid Control 10g, 11g and 12c. Setting up administrator, Notification rules and Alerts for monitoring enterprise infrastructure and databases.

Extensive experience supporting Oracle Applications 12.0.3. Supported ETL jobs to move enterprise data to Oracle EBS 12.0.3. Installed and supported OBIEE 11.1.1.9 on Linux with WebLogic server 10.3.

Performance tuning database by generating ADDM, AWR and ASH reports. Analyzing the reports and proactively working on potential issues. Involved with sev 1 issues with the D2000 environment and resoling production issues as and when they occur.

Extensive experience backing up, restoring and duplicating databases to EMC, 3PAR and PURE SAN and Networking Appliance’s NAS storages using Oracle Rman. Used RMAN to refresh databases, created duplicate databases and Data Guard. Replication of data using Oracle Stream. Implemented Oracle Streams to capture, propagate, and apply the transfer of data.

Designed AWS infrastructure to move our local applications to hybrid cloud. Provisioned servers, involved in setting up VPNs, VPCs, and provisioned database servers including AWS RDS instances. Established Standards of Operating Procedures to migrate, and manage applications to cloud.

Extensive experience in implementing database security using user’s profiles and roles. Extensive experience using VPDs, tuning VPD queries and controlling access to database. Used Advanced Security Options, Oracle Database Vault and FGA to secure database. Using database Vault to protect application data from being accessed by privileged database users, discover Oracle Database runtime privileges without disruption.

Exposure to NoSql, MySQL, PostgreSQL, MongoDB, Hadoop, Big data and AWS cloud. Used AZURE to create development database in cloud.

CERTIFICATIONS:

Certified ORACLE 10g, 9i, 8i DBA and 8 DBA from Oracle (OCP).

Certified PMP from PMI.org.

Oracle 10g and 9i RAC Training from Oracle Corporation.

PROFESSIONAL EXPERIENCE

Veros Real State Santa Ana

Sr. Oracle DBA Lead

Jun’16 – May’17

Achievements: Tuned production queries to elapsed time of less than 2 mins using Statspack. Queries used to take more than 8 mins. Also helped in tuning load testing.

Responsibilities

Lead a team of DBAs to support enterprise databases, setting standards, proactively monitoring database to identify any issue that may bring down database.

Experience working with off-shore development teams to coordinate development work, assigning the work and implementing it. Identifying and supporting implementation of process improvements. Identifying and completing any other tasks to help ensure the success of the projects.

Worked with software engineers, security administration, computer operations, and network managers to ensure quality and integrity of databases, applications, software, and data.

Installation, support and administration of all the versions of databases up to 12c. Upgrading databases to 12c. Supported production databases 12c, 11g and 10g. Extensive Experience in Installing, configuring, patching and applying Critical patches to databases.

Installed, upgraded and managed and supported SQL Server 2008 and 2012 databases. Supported Backups, log shipping, clustering, and or replication experience. Supported SQL Server Reporting Services (SSRS) and SSIS. Used SQL Server Configuration Manager in order to disable unnecessary features and services.

Supported developers to provide day to day support, including tuning query optimization, refresh and any other dba related tasks. Reviewed PL/SQL codes and rewriting them whenever needed. Strong performance tuning experience.

Implemented database security using user’s profiles and roles. Also implemented VPDs, tuned VPD queries and controlling access to database. Used Advanced Security Options, Oracle Database Vault and FGA to secure database. Used database Vault to protect application data from being accessed by privileged database users, discover Oracle Database runtime privileges without disruption. Configuring Realms, rule sets, command rules and factors to configure database Vault. Extensive experience using RMAN and Data Pump in Database Vault environment.

Regularly reviewing AWR reports and Statspack reports for potential issues and proactively tuning databases.

Maintained different DEV/TEST/ACPT/INTG environments for development and testing purposes. Cloning these environments from production environment using Backups. Selectively copying data from production to non-production environment.

Installing, upgrading and supporting 12c database. Supporting developers to test application on 12c database.

Extensive RMAN, backup and recovery, day-to-day support exp. Refreshing databases using RMAN. Extensive experience in restoring, recovering and refreshing databases using RMAN. Tuning RMAN backups. Restore and recover databases using RMAN.

To drill down to the root cause of Oracle database performance issues by analyzing include Oracle wait events, SQL plan changes, blocking, I/O, network bandwidth, etc. using Statspack. Worked with developers to provide then day to day support, including tuning query optimization, refresh and any other dba related tasks. Reviewed PL/SQL codes and rewriting them whenever needed.

Installed, Administered and Supported SQL Server 2008 and 2012 databases. Supported users and

Writing and debugging UNIX shell and Python scripts to monitor databases, jobs, data loads and other database related jobs.

Using Jira ticketing system for tracking the changes and moving them from dev to test to integration to production environment.

Installing, creating and administering PostgreSQL databases, writing queries to retrieve databases, using JSON type, arrays, subqueries, etc. Writing complex queries using Oracle XML, XPath and XQuery.

Auto club of Southern California Costa Mesa

Sr. Oracle Production DBA Lead

Mar’12 – May’16

Achievements: When I joined Auto Club, Backups of production and non-production databases used to take very long time. I tuned the backup scripts to reduce the time by 70%.

Responsibilities

Designed the storage and server solutions as per best practices. Planned team strategies, organised meeting with DBAs to get the status every week. Recommending and establishing standards, guidelines, and procedures for all aspects of data modeling, database design and maintenance. We use monthly checklist to monitor databases. Participate in capacity planning, keep up-to-date patching and supporting any efforts related to the enterprise databases.

Lead various enterprise projects, including data center move to Texas. Planning, identifying stakeholders, calling bi-weekly meetings, tracking the resources and progress of the projects, identifying bottlenecks to implement the projects on time.

Lead the datacenter automation project using Orchestrator to automatically switch data center from California to Texas.

Worked with software engineers, security administration, computer operations, and network managers to ensure quality and integrity of databases, applications, software, and data.

Installed, supported and administered all the versions of databases up to 12c. Supported production databases 12c, 11g, 10g, 9i, 8i and 8 and Oracle Applications e-business suite R12 and 11i.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008/2012. Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer. Implemented Always ON for the replication of SQL Server databases. Wrote SSIS packages.

Expose to high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).

Designed, installed and configured DB2 databases in the test, development and production environments

Performed and troubleshooted database backup, recovery. Administered, maintain, and implement changes to existing databases.

Installation of OBIEE 11.1.1.9 on Linux with WebLogic server 10.3.

Writing complex queries using Oracle XML, XPath and XQuery.

Supported mission critical D2000 application database. This application is using 11g R2 2 node RAC database with 2 node RAC standby database for disaster recovery. We use this for DR testing also by breaking the replication. For that I take the flashback of the standby database and I open it for read/write. Once testing is done I restore it from flashback and re-enable the replication. I am also using data guard configuration with data guard broker to facilitate switchover and failover.

Designed and implemented Disaster Recovery Solutions for mission-critical production database servers. Designed and implemented Oracle RAC 11g Disaster Recover Solutions for D2000 systems. Designed, Tested and implemented Disaster recovery solution using Oracle Data Guard.

Designed and implemented GoldenGate data replication processes. Developed GoldenGate system macros, analyzed applications for GG suitability. Identified and remediated data synchronization issues.

Provided expertise on Oracle Golden Gate and configured Golden Gate and troubleshoot the issues related to Golden Gate independently. GoldenGate performance tuning/troubleshooting and GoldenGate replication production support

Used GoldenGate 11g Release 2 to copy data from SQL Server data into oracle databases.

Extensive experience of OEM Grid Control 10g, 11g and 12c cloud control installation and configuration. Monitoring enterprise databases using grid control, creating rules, administrators, etc. Setting alerts are per the responsibilities of administrators. We proactively monitor databases using grid control and with the help of monthly checklist keep track of resource intensive SQLs.

Extensive RMAN, backup and recovery, day-to-day support exp. Refreshing databases using RMAN. Extensive experience in restoring, recovering and refreshing databases using RMAN. Tuning RMAN backups. Restore and recover databases using RMAN.

To drill down to root cause of Oracle database performance issues by analyzing include Oracle wait events, SQL plan changes, blocking, I/O, network bandwidth, etc. using AWR. Used ADDM (Automatic Database Diagnostic Monitor) to see the Top SQL which are causing performance issues, along with the ability to make suggestions for improvements.

Extensive experience supporting Oracle Applications 12.0.3. Supported ETL jobs to move enterprise data in to Oracle Applications 12.0.3.

Administrating ODA, managing databases on ODA, adding Disk, Cloning vdisk, patching Databases in ODA, validating the installation. Moved Oracle 11g R2 RAC database to ODA using RMAN backup to ODA.

Using ASH (Active Session History) to help determine 'current performance related issues. Analyzing ASH report to find out culprit session and concurrency issues.

Optimize the performance of the database by ensuring the best possible database throughput and response time

Set up of data guard in 11g RAC environment, monitoring Standby database for any lagging.

Work with developers to provide then day to day support, including tuning query optimization, refresh and any other dba related tasks. Reviewed PL/SQL codes and rewriting them whenever needed.

Day-to-day support to developers and users. Strong performance tuning experience. Exposure to Golden Gate

Maintained different DEV/TEST/UAT environments for development and testing purposes. Cloning these environments from production environment.

Extensive Experience in Install, configure of database software and patches. We regularly apply Critical patches.

Platform migration from HP UNIX to Linux. I recently migrated 11.1.0.7 RAC database from HP UX to 11.2.0.3 RAC database on RHEL 6

Helped moving data center from LA to TX. Planned to move all the servers and databases to Taxes. Also planned and moved servers, created a new standby database in TX and switched to TAX.

Used Orchestrator to automate databases switchover and failover. Wrote scripts and integrated them into Orchestrator for automatic switchover and failover.

Installing, creating and administering PostgresSQL databases, writing queries to retrieve databases using JSON type, arrays, subqueries, etc.

Using Serena ticketing system for tracking the changes and moving them to production environment.

Writing and debugging UNIX shell scripts for cron jobs.

Supported MySql, NoSql, Big data and AWS cloud, and used AZURE to create development database in cloud.

Kaiser Permanente Corona

Solutions Consultant, Disaster Recovery

Oct’10 – Mar’12

Responsibilities

Designed, Architected and implemented disaster recovery solutions for production databases of Oracle. Leading different IT projects for deploying Disaster Recovery solutions. Leading meetings for Disaster Recovery design reviews, writing procedures and implementing the solutions.

Lead disaster recovery project for database failover and business continuity.

Installation, implementation and configuration, and setting up administrator, Notification rules and Alerts for Grid Control 10g and 11g. Develops and monitors automated process, backups and concurrent managers and alerts.

Technical Support for customer problems and ticket resolutions. Database and Applications security administration.

Created Data Guard as a disaster recovery solution for production databases. Created Physical standby databases using RMAN. Also implemented cascaded standby databases to move Standby databases from one data center to other data center.

Installation, support and administration of 11g and 10g RAC oracle databases. Installed and created 11g databases. Upgraded 9g and 10g databases to 11g for development. Tuning database using AWR, ADDM and ASH reports.

Maintained different TEST/DEV/ STRESS environments for development and testing purposes. Refreshing non-prod environment from production backup.

Upgraded databases and underlying hardware. Planning and implementing solutions to upgrade Oracle software and OS.

Extensive experience backing up, restoring and duplicating databases to EMC’s SAN and Networking Appliance’s NAS storages using Oracle RMAN. Used RMAN to refresh databases, created duplicate databases and Data Guard.

Installation and implementation of 10g RAC, monitoring of RAC specific waits in the databases and performance tuning database. Installation of 11g grid control to monitor databases. Monitoring and performance tuning databases using Grid control.

Designed AWS infrastructure to move our local applications to hybrid cloud. Provisioned servers, involved in setting up VPNs, VPCs, and provisioned database servers including RDS instances. Established Standards of Operating Procedures to migrate, and manage applications to cloud.

Managed database scripts for different builds, version controlling and preparing scripts for release to court, testing release scripts etc.

Installed and implemented golden gate for reporting database.

Understanding of NoSQL, Big data and AWS cloud for handing high volume data.

Deloitte, Inc. Santa Ana

Client: Department of Justice, California

Sr. Oracle DBA

Feb’ 07 – Sep’10

Responsibilities

Supported full project development life cycle. Designed and developed databases for V3 Project. V3 is a project developed by Deloitte Inc for Administrative Court of Justice, California. Created and upgraded oracle 11g, 10g and 9i databases. Worked with the project team to discuss design of databases. Participated in regular project meetings. Worked closely with developers to optimize and tune new queries based upon new enhancements and defects. Prepared data scripts using DDL (Data Definition Language) and DML (Data Manipulation Language) for new enhancements and defects.

Supported multiple Oracle 11g and 10g databases on HP-UX, Solaris and RedHat Linux, periodically refreshing DEV, Test, PAT and Stress environments using backups & data pump export/import.

Regular patching of DEVT/TEST/SANDBIOX and Production environments.

Managed database scripts for different builds, version controlling and preparing scripts for release to court, testing release scripts etc.

Used Clear case and Clear Quest to maintain different versions of data scripts.

Multiple node installation of 10g RAC environments, installation of Oracle Clusterware, ASM databases and RAC databases. Support to RAC databases, resolving issues, etc. Converted non-RAC databases to RAC databases. Added new nodes to existing RAC installation, troubleshooted performance issues.

Writing stored procedures using PL/SQLs to support developers to fix issues related to database.

Installed and patched databases, upgraded databases from 9i to 10g and 11g, 10g to 11g. Prepared documentation to write down the instructions to upgrade court databases. Applied CPUs.

Tuned different components of memory. Tuning SQL Optimizer, using different parameters of optimizer.

Used ASMM to automatically tune memory. Used Automatic Workload Repository to collect extended statistics. Used Automatics database diagnostic Monitor (ADDM) which uses AWR information to tune database.

Extensive experience using AWR report and Statspack report to proactively tune database and queries.

Implemented Oracle Streams to capture, propagate, and apply the transfer of data.

Backing up, restoring and duplicating databases using rman. Wrote RMAN scripts to backup databases using Net backup.

Ameriquest, Inc. Orange

Sr. Oracle DBA

Feb’ 04 –Feb’07

Responsibilities:

Designed, created and upgraded new databases. Supporting existing databases for Ameriquest Mortgage.

Supported Oracle 10g and 9i production OLTP database on Solaris, HP-UX and RedHat Linux for Ameriquest mortgage. Installation, support and administration of 11g and 10g databases.

Installed and supported 2 node 10g RAC production environment. Troubleshooted and resolved performance issues related to RAC databases. Tuning of interconnect. Enabled NIC bonding for cluster interconnect.

Tuning global cache directory. Re-mastering of the blocks for better performance.

Monitored RAC specific waits in the databases and tuned the database for better performance.

Installation and management of 10g grid control. Setting alerts and configuring new databases thru Grid control to monitor databases.

Supported data warehouse databases of more than 3 Terabytes.

Implemented SOX on production EMPOWER database as per the SOX guidance.

Worked closely with Informatica team to populate data warehouse database using ETL.

Performed number of schema refreshes from production to test and dev using data pump.

Implemented Shareplex for replication of production EMPOWER database for reporting purposes.

Used Materialized views to replicate subset of database.

Planned and implemented backup strategies using Net backups, planning disaster recovery. Using RMAN to backup and restore/refresh databases.

Extensively used RMAN to Backup, refresh and restore DEV, TEST and QA databases to EMC SAN storages.

Installed, patched and upgraded databases, Applied Server patches to upgrade Oracle binaries.

Used Oracle Application Express (Oracle APEX) for rapidly development of web application for the Oracle databases. Supported database using Oracle Enterprise Manager and Toad.

Network Appliance, Inc. Sunnyvale

Sr. Oracle DBA

Feb’ 01 – Feb’ 04

Responsibilities:

Designing and creating new databases, supporting and upgrading existing databases, supported developers to day to day activities.

Support large, enterprise deployments of multiple instances of Oracle E-Business Suite (EBS).

Supported Oracle Applications 11.5.7 and 11.5.8, patching, system administration, concurrent managers, creating custom responsibilities and menus, etc. Supported two-tier architecture with Apache web servers load balanced.

Cloning Non-prod from prod, troubleshooting concurrent managers, supporting users.

Supported Workflow (troubleshooting, re-assigning, set-up, and performance).

Managing concurrent program. Supported Table / User Auditing and Alerts. Starting / stopping Concurrent Manager and Application Servers.

Regularly working with Oracle support on SARs and any Oracle Applications functionality issue.

Capacity planning and disaster recovery strategy in case of disaster. Goal was to achieve 99.9999% availability of production databases.

Installation of Oracle Enterprise Manager 9.2. Monitoring databases using OEM, creating alerts, etc.

Capacity planning and disaster recovery strategy in case of disaster. Goal was to achieve 99.9999% availability.

Replication of database using Shareplex and Data Guard for reporting purposes.

Millennium Vision Corp. Redwood City

Oracle DBA

Sep’97 – Feb’01

Responsibilities:

Data modeling to design and implement the database.

Managing Rollback Segments and Temporary Segments. Reducing contention for Rollback Segments.

Tuning Memory allocation, tuning I/O and reducing contention. Tuning SQL statements to improve the performance of SQL statements.

Supporting Production and Data warehouse databases. Taking cold and hot backups and implementing Backup/Recovery.

Supporting to clients for their day-to-day problems. Writing Stored procedures using PL/SQLs.

Replication of database using Data Guard. Also created materialized views to replicate tables.

Wrote shell scripts to take backup and monitor databases.

EDUCATION

MS in Computer Science, INDIA.

Contact this candidate