PROFESSIONAL SUMMARY:

• About 13 years of Extensive Experience, Advanced - Level DBA Expertise and In-Depth knowledge across 3 RDBMS platforms: Oracle, DB2 and MySQL
• Worked as MySQL Database Lead for a team of highly experience MySQL DBA’s providing support on complex MySQL architectures that spans geographically separate locations.
• Previously working as Senior Database Specialist with full accountability and ownership of multiple Database Environments (Development, Test and Production) in large, complex data centers providing complete DBA support to multiple database platforms (Oracle, DB2 and MySQL) on Solaris, Linux and HP-UX OS
• As the Skill-Center Leader, led a team of experienced DBAs spread across 2 continents providing Technology/Engineering services and DBA support to critical business areas which include Hosting Services, Level-3 Production Support, Presales support, Solution Design, etc.
• Worked in a broad range of technology roles, specializing in the DBA arena, with intimate hands-on expertise in all major DBA activities on Oracle, DB2 and MySQL including Design, Build, Installation, configuration, support, performance tuning, automated and manual backups, RAC, Data Guard, DB2 HADR, Oracle RMAN, Replication, GoldenGate etc.
• Thorough understanding of Database architectural components and storage structures with deep knowledge and hands-on experience in managing, validating, troubleshooting and resolving complex issues in Oracle, MySQL and DB2
• Good knowledge and trained in Big Data platforms and technologies including Oracle NoSQL, HBase, Cassandra and MongoDB
• Excellent knowledge and experience as an Administrator and Advanced User on multiple Operating Systems including Solaris, Linux and Windows
• Key member of ‘Prescription Group’ responsible for developing central standards, protocols and guidelines, along with study, analysis and validation, for all databases used within organization including Oracle, MySQL, DB2, Cassandra, HBase, MongoDB, Oracle NoSQL and PostgreSQL
• Key member of ‘Big Data Analysis Group’ doing detailed comparative analysis and study of open-sourced Big Data solutions, primarily Hadoop and HBase.
• Actively involved in client-facing roles, providing strong partnership and support to multiple business groups including Pre-sales, Engineering, Product Management, Client Support etc. around business-critical technology decisions related to Hosting and Database solutions, Production issues, special client requirements etc.
• Actively involved in drafting of annual engineering budget, estimation and costing of standard services and making presentations to senior management
• Personnel Management and Skill-Center Management: functioning as Corporate Technology Trainer providing various levels of technical training on multiple DB platforms to internal employees and external clients. Creating and Maintaining central knowledge repositories
• Excellent problem solving, written and verbal communication skills, with effective leadership and team skills

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11gR2, DB2 9.5/9.7, MySQL 5.0/5.1/5.5/5.6/5.7, Oracle NoSQL, Cassandra, MongoDB, HBase, MS Access

Languages: Shell Scripting, Perl Scripting, SQL, PL/SQL, C, C++

Operating Systems: Linux(RHEL 4,5.4,5.5,6.2; Ubuntu 15.04, 15.10), Solaris(SPARC 5.8,5.9,5.10), Windows 2000/XP/NT/2003 Server

H/W & Appliances: Oracle Exadata V2

Packages/Tools: MySQL Enterprise Monitor (MEM) v3.0, Networker, emc Avamar, BMC Patrol, Cacti, HP Openview (OVOW), TOAD, Netapp (Data ONTAP), NetApp SMO, BMC Bladelogic, PL/SQL Developer, VMWare, Partition Magic, System Mechanic, Disk Druid, VncViewer, WinSCP, Putty, SecurCRT

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Support Production, UAT, Development Oracle and MySQL Databases
• Support and Manage MySQL databases
• Manage Oracle Databases on replication environment
• Troubleshoot issues on Oracle Data Guard
• Diagnose Performance related issues
• Provide on-call support
• Support backend Oracle databases for multiple financial and HR applications
• Manage Oracle FSFO using Data Guard
• Setup Oracle and MySQL databases and backups on virtual hosts

Confidential, Bellevue, WA

Software Design Engineer

Responsibilities:

• Managing MySQL Cluster Replication Architecture using Master-Master synchronization
• Creation and setting up of complex backup and monitoring script for an architecture involving multiple MySQL engines and using MySQL Cluster, MySQL Replication and Standalone technologies
• Providing support to Development teams on MySQL
• Setting up of monitoring for MySQL instances using MySQL Enterprise Monitor (MEM)
• Designing, developing and implementing databases and database utilities.
• Perform database analysis and design reviews
• DB Administration on multiple RDBMS platforms
• Testing of Database platforms
• Creating knowledge Center articles having descriptive information on Incident and Problem Management of MySQL issues
• Post-deployment production support
• Developing complex shell scripts for management of MySQL instances on Standalone and Replication environments
• Resolving issues on MySQL Replication, Standalone and Cluster architectures
• Customizing MySQL Replication using SQL and parameter files
• Automation of Backup and Monitoring of MySQL instances using shell scripts and subsequent generation of email and sms alerts to DBA team
• Supporting on Percona MySQL Cluster setups
• Migration of MySQL Replication Production environments from Solaris to Linux servers
• Management of MySQL instances on Galera Cluster
• Management of MySQL Master-Master replication architectures on Production, Staging, Development and Test environments
• Troubleshooting of issues on MySQL instances
• Supporting developers on various issues at database level
• Running scripts and queries to support new releases
• Using MEM for monitoring of MySQL instances
• Managing MySQL backups

Confidential

Senior Database Specialist

Responsibilities:

• Primary owner, point of contact and knowledge source for all Oracle, DB2 and MySQL Databases and Engineering services.
• Acting as Skill-Center Leader for the Database Engineering team spread across India and France
• Installation and deployment of databases on Oracle, DB2 and MySQL from ground up, and ongoing Level-3 support and maintenance
• Installation and configuration of Oracle Standalone, RAC, GoldenGate & Data Guard Architectures
• Validation and thorough failover testing for setting up DB2 HADR for production environments
• MySQL Master-Slave replication and validation
• D Core Database Administration Responsibilities evelopment, Set-up, validation and operation of complex Backup and Recovery Procedures/Tools for Oracle, DB2 and MySQL with the ability to support multiple backup options, restoration, point-in-time recovery, report generation, backup validation etc
• Validation and implementation of backup solutions including the usage of Storage Clone and reverse Clone technology (using NetApp SMO)
• Setup and validation of DB2 Backup and Recovery solutions using Netbackup
• Validation and implementation of multiple DB architectures including MySQL Cluster (NDB 7.2), MySQL Replication, MySQL using 3rd party Cluster etc
• Integration of Bladelogic for all Oracle, DB2 and MySQL tasks, that cover auditing, reporting, validation and other administrative tasks, including development of scripts for automated discovery of Oracle (standalone, RAC & Data Guard) and MySQL instances on a server
• Validation and configuration of new features and tools, including Patrol, in MySQL, Oracle and DB2 for internal teams and external customers
• Creation and implementation of Silent installation scripts in customized MySQL master packages for RHEL and Solaris
• Validation of PostgreSQL for new service offerings in Catalog
• Management of PostgreSQL instances in Unix environments
• Providing Level-3 Production support (highest level) on Oracle, DB2 and MySQL databases to a global customer base
• T Support roubleshooting and resolution of critical issues in the areas of performance, administration, backup, recovery etc
• Supporting customers on all validated technologies and architectures in RDBMS, including Clusters, Replication and GoldenGate
• Efficient, real-time support to Pre-Sales team
• Supporting and collaborating with clients for solution designs, technical decisions, promotion of service offerings (Hosting, Database solutions etc.)
• O Database Migrations racle database migration from version 8i to version 10g on a different server
• Migration of MySQL databases across servers
• V Unix Administration alidated ZFS Snapshot technology to be used with MySQL
• Performing basic Unix administration for Oracle database performance improvements
• Linux LVM administration for managing database volumes on lab servers
• Developed a customized procedure for refreshing and synching up DEV databases with PROD using a combination of concepts like Oracle Flashback, Data Guard, and RMAN.
• D Innovation, Workflow Automation/ Optimization eveloped a tool, similar to runInstaller of Oracle RAC, for setting up MySQL on a multi-node Veritas Cluster environment. The tool performs all prerequisite checks, sequentially installs MySQL on all nodes and customizes the startup scripts.
• Developed a health-monitoring tool for MySQL Replication environments for performing automatic creation and customization of Replication health-check scripts
• Developed scripts to be used by Bladelogic for Oracle and MySQL Inventory Management. Included Oracle Standalone, Oracle Data Guard and Oracle RAC
• Created a script for existing MySQL VCS environments to help detect and avoid multiple nodes accessing the same instance simultaneously, without the need to shutdown MySQL instance. This helps prevent data corruption and errors
• Developed, automated and documented a complete procedure for taking MySQL Snapshot backups using ZFS technology
• Developed a Bladelogic script to extract, calculate and report data size and log space usage by Innodb and other engine types. Provides automated report for all instances
• Customization of Oracle RMAN backup procedures through Networker using pre and post command features
• Automated and standardized build procedures for Level-2 DBA Team members by developing the following tools:
• Automated silent installation and creation of Oracle databases
• Automation of Oracle RMAN Setup for generating DB backup scripts
• Packaging of custom-compiled MySQL binaries and scripts on Linux & Solaris
• P Analysis and Studies erformed an in-depth technical analysis and feasibility study of Oracle Exadata V2 to evaluate the option of migrating over a thousand Oracle databases from HP servers to Exadata and usage of Exadata for DBaaS. Published a detailed report & risk matrix.
• Performed comparative analysis of Oracle Exadata V2 and EMC Greenplum
• Performed comparative analysis of SAP HANA and Standard Oracle 11g DB for SAP
• Performed analysis of Oracle 11gR2 Flashback Database Technology features to explore options for Recovery SLA improvement
• Performed analysis of Oracle RMAN features of Incrementally updated backups
• High-level analysis of Oracle Maximum Availability Architecture (RAC+Data Guard)
• M Personnel Management, Mentoring and Skill-Center Management anaging a team of 6 Database Specialists: delegation of responsibilities, status checks, handling escalations, providing technical guidance, etc
• Support, guidance, technical trainings and mentorship to new/junior team members, level-2 DBA’s and other global teams on Oracle, MySQL and DB2
• Drafting of annual Engineering Budget for the Skill-Center. Costing of standard services
• Management of Internal as well as External employees for optimum utilization

Confidential

Senior Oracle DBA

Responsibilities:

• Administration of Production, Development and Quality Assurance databases on Oracle Clinical
• Maintenance work including backups, troubleshooting of database issues
• Development of tools and shell scripts
• Performance Tuning

Confidential

Oracle DBA

Responsibilities:

• Responsible for Administration and support of multiple databases spread over multiple datacenters including Production, Staging, Acceptance and Reporting
• Maintenance activities including Performance tuning of databases and application queries, space maintenance, sessions monitoring, cron jobs scheduling, performance monitoring, schema refreshing
• Supporting customer request around Data extraction, issue resolution and troubleshooting
• Developing shell scripts and Oracle packages/procedures for generating customized reports for clients
• Resolving bugs and issues in Oracle packages and procedures

Confidential

DBA Consultant

Responsibilities:

• Maintenance of 5 Oracle 9i databases on 2 NT servers, including SIT, PROD and UAT Databases
• Regular maintenance activities including scripts verification, monitoring, sizing, performance analysis
• Maintenance of 15 Oracle 8i databases on 7 different servers maintained on Windows NT and Sun Solaris 5.8 (on Sunfire 6800, V880, V240 and Ultra Enterprise 4000)
• Maintenance activities including managing users and roles, hot & logical backups, creating/configuring listeners and services, monitoring of Tablespaces, datafiles and control files, creating DB links, cronjobs
• Maintaining Standby database and regular application of archive logs generated from production database.
• Performance monitoring using STATSPACK reports and various dynamic views
• Taking daily Hot backups on tapes using Storedge L20 with Legato software. Doing configurations and troubleshooting of Legato and the Storage device. Hot Backups taken on 200GB LTO data cartridges
• Taking daily export backups through Storedge D240 using 40GB dds-4 data cartridges
• Creating scripts on Solaris and Windows OS for automating activities such as backup scheduling, SQL procedures, ftp, removing dump files, OS files size monitoring, and mailing of alerts
• Migration of 8 different databases from 3 servers onto a single Sunfire 6800 server
• Resolution of critical database errors and recovery of databases
• Migration of Oracle 9i production database on Windows 2003 from old IBM server to new IBM server.
• Redistributed control files and log files over different disks through multiplexing.)
• Installation of Oracle9i database on Windows (2003 Server edition) platform & establishing connectivity
• Supported configuration of Baan ERP with Oracle 9i
• Installation of Oracle10g database on HP Proliant Server (Linux AS4 platform)
• Installation of Oracle Developer suite 9i on Windows.
• Installation of Linux AS3 on an IBM server after performing formatting and partitioning activities
• Installation of Oracle 10g (v10.1.0.2) and two new databases
• Migrating two databases (Oracle 9.2.0.1 on Win 2000 and 8i on NT) from two different servers to the new server. Simultaneous operation of both databases, and established Client Connectivity

Confidential

Senior Engineer

Responsibilities:

• Administration and maintenance of a databank of product defects and failures. The database was initially supported on Microsoft Access. Migrated to Oracle 9i in 2004.
• Oracle software Installation. Creation of database, including table and index design, application of constraints, creating joins, creating different types of views, creating temporary and undo segments etc
• Creating users and assigning roles and privileges
• Database back-up and data recovery through User-Managed procedures, including creation and maintenance of recovery catalog
• DB server configurations involving listeners, naming methods, service registrations etc.
• Data Trend analysis of consumer complaint and product failure data
• Developing queries and procedures for data retrieval and data updates
• Data download from SAP system, report generation and data transfer in the main database
• Maintenance of user workstations and servers. Activities include hard disk partitioning, installation of operating systems (Windows and Linux), backups and disk formats within multiple partitions, creation of users and role assignation, managing disk partitions etc.
• Designing and developing Transaction Codes in SAP
• Developing macros and user-defined GUIs using Access Forms