SUMMARY

• Over 20 years of experience in IT Industry working as a DBA in Development and Production.
• Had done various Oracle projects using RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, cloning, patching, Performance Tuning.
• For the recent 7 years, focused on NOSQL databases like Confidential, Cassandra with all DBA tasks.
• Excellent experience in Installation and configuration of different databases on OS LINUX and Windows
• Planned and scheduled the Physical (Cold / Hot) backups as well as Logical backups for Oracle/MSSQL Server/MySQL/Vertica/ Confidential /Cassandra/CouchBase/Redis databases.
• Experience in management tools like Oracle Enterprise Manager, TOAD and SQL Developer.
• Hands On and Knowledge of Real Application Cluster (RAC) and GoldenGate Replications.
• Provided 24x7 Remote / on - call production supports.

TECHNICAL SKILLS

• Vertica 5/6/7, Hadoop, Confidential 2/3/4, Cassandra 2.x, CouchBase 2/3, TokuMX, MySQL 5.5/5.6 - Oracle RDBMS 7x, 8i, 9i, 10/11G RAC- Oracle ERP 11.0.3 / 11.5.9 / 11.5.10 - Grid Control 10G Oracle Application Server / Discoverer 10G R1/2 PL / SQL - SQLPLUS - TSQL Informatica 7/8/9 MS SQL 2000/2005/2008/2012 - Unix / RedHat/Ubuntu/CentOS Linux / AIX - ksh / csh / bsh / bash - Perl. Netapp FAS 2050/3040 - Ontap 6 versions

PROFESSIONAL EXPERIENCE

Confidential Engineer (consultant)

Confidential, Milpitas, CA

Responsibilities:

• Support Cisco Policy Suite (CPS) software in term of developing and administrating Confidential databases hosted by the software. It includes sizing, upgrading, designing, troubleshooting, performance tuning, indexing, backup/recovery for replications and sharding Confidential environments in VMware and Openstack
• Be familiar and well versed on supporting software and tools like Grafana, graphite/Prometheus, Jenkins, HAProxy, REST API, SVN interface, GIT
• Implement Confidential databases with automating a variety of tasks, using Bash, Python, Java, C++, mongoshell

DB Security Engineer

Confidential, Sunnyvale, CA

Responsibilities:

• Set up security guidelines for all supported databases in the company like Confidential, Oracle, Vertica, MS SQL Server, MySQL by providing DB roles, automated scripts (java, python, javascript, perl, shells, powershell) to monitor and verify the environments
• Write Java codes to deliver strictly rules, alerts, maintenance to Confidential instances related to DBAs
• Implemented Mongo Management Service for automating a variety of tasks, including backup/recovery and performance management
• Assist developers in detecting performance problems using MMS and Mongo Profiler
• Work with devops, apps, dba teams to secure on applications, clients/servers, data transferring, data storage

DevOps DB Engineer (consultant)

Confidential, Santa Clara, CA

Responsibilities:

• Automated, configured, upgraded, supported and resolved all issues related cluster/native replications to MariaDB 5/10 and Oracle 11g databases in VM cloud infrastructure
• Participated on all activities in DevOps environment for all company product releases translated business requirements into technical specifications and build elegant, efficient, and scalable solutions based on specifications
• Installed, configured, monitored, and supported the following databases: MS SQL Server 2008/2012/2014 instances (MS Azure), Vertica 7.x, Confidential 2.x (AWS), PostGresql 9.x, Hadoop for uptime, availability and functionality and ensure SLA's are met
• Managed, configured, upgraded, monitored and tuned Confidential instances on AWS environment
• Developed Confidential and API prototypes and proofs of concept
• Implemented Mongo Management Service for automating a variety of tasks, including backup/recovery and performance management
• Provided configuration, monitoring, setup, deployment, troubleshooting support to the company tools like Zenoss, Splunk, LogicMonitor, Jenkins, Ansible, GIT
• Automated scripts for monitoring, alerting, maintaining DB environments
• Participated in product releases from staging to production, VM to MS Azure migration and some products in AWS environment
• Be responsible for availability, latency, performance, efficiency, change management, monitoring, emergency response, and capacity planning
• Worked on with a global team of SREs to help resolve issues in production, test and development

Sr. Database Administrator

Confidential, Foster City, CA

Responsibilities:

• Provided and design tools to assist in the management of the database and transaction processing environment.
• Worked to provide a working model of our transaction processing environment for capacity assessment and planning.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.
• Developed a security scheme for the database environment ( Confidential and MS SQL Servers), as well as assisting in disaster recovery if necessary. Performed upgrading, replicating, sharding, tuning all 3.2 Confidential instances
• Implemented Mongo Management Service for automating a variety of tasks, including backup/recovery and performance management
• Provided leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications.
• Worked with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments (MongoDBs and MS SQL Servers).
• Worked with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Supported MS SQL Server 2014, MySQL 5.6, Confidential 3.x, Postgresql 9.2 databases

Sr. Database Administrator

Confidential, Palo Alto, CA

Responsibilities:

• Worked with App Architects for each game to create, size, shard, backup/restore, monitor the replication sets for all Confidential instances
• Maintained a large deployment of database servers on a variety of complex and differing technologies
• Reviewed schemas and queries on hosted database solutions
• Optimized the implementations and developed best-in-class performance for the supported products
• Provided and implementing solutions for real time development and production tasks for existing and upcoming products
• Automated mundane database activities such as monitoring, backups and reporting with shell/perl/python
• Documented the database procedures and policies for knowledge sharing
• Supported various databases in terms of installation, configuration, upgrade, monitor, tuning, backup and restore: Vertica 5/6/7, Confidential 2/3, CouchBase 2/3, Mysql 5.x, TokuMx, Cassandra, ElasticSearch, Redis
• Implemented appropriate indexes (B-Tree, Geospatial, Text) for performance improvement ( Confidential )
• Responsibilities included configuration, provisioning, upgrading and decommissioning databases
• Monitored production deployments for capacity issues, performance, troubleshooting and DB tuning
• Actively participated in production database support
• Worked with development team to verify and validate schemas and queries for performance and scalability
• Provided guidance and suggestions for new and improved technologies
• Involved with other teams to migrate in-house applications to Google Cloud: GAE/GCS/Google-SQL

Sr. Cloud Database Administrator

Confidential, Newark, CA

Responsibilities:

• Installed, configured, monitored, and supported the following databases: MS SQL Server 2008/2012 instances, Vertica 5.x, Confidential 2.x, Hadoop for uptime, availability and functionality and ensure SLA's are met
• Implemented MMS for alerting DBAs as well as automating a variety of tasks, including backup/recovery and performance management
• Supported multi company products on the Amazon platform including windows, linux, EC2 volumes, EBS snapshots
• Worked with the DBA team to strategize performance metrics, backup and disaster recovery for all databases
• Developed scripts in bash, perl, powershell to automate checking and monitoring the databases
• Coordinated with Dev teams to roll out to production the application new versions, patches
• Owned the operational lifecycle from release to retire (change / problem / incident management)
• Worked alongside Software Developers to design, build and roll out / upgrade new versions

Sr. Oracle DBA

Confidential, San Bruno, CA

Responsibilities:

• Monitored and troubleshooted Microsoft SQL/ Oracle Database performance and scalability issues
• Performed upgrades and migrations
• Implemented backup/recover procedures for new and existing environments
• Periodically performed backup/recovery dry run to validate the backup/recover procedures
• Developed Database Administration automation scripts
• Developed and maintained ETL processes to support the data warehouse on Microsoft SQL Server
• Interacted with the Customer Support and Professional Services Organizations in the capacity of Tier 2 support for Customers.
• Provided technical and business guidance for complex user problems
• Identified and developed tools to assist in Production Support and Operations ability to troubleshoot Database and application related issues
• Documented Standard Operating Procedures for Production Support/Operations team
• Provided design assistance to Engineering for new and existing releases
• Performed configuration and monitoring GOLDENGATE replication processes

Sr. Oracle / MSSQL DBA

Confidential, Milpitas, CA

Responsibilities:

• Planned, coordinated and administered matters related to Oracle/SQL server database(s), including base definition, structures, documentation, upgrades, long-range requirements, operational guidelines and protection.
• Revised, implemented the Backup and Recovery Jobs (OEM - Rman) as well as the Database monitoring system. Established and maintaining security integrity controls.
• Managed the following: troubleshooting, recovery, tuning of the database, software installation and upgrades, resolving Oracle9i /10g (Sun Solaris - NetApp Filers - FAS 3040/2050/200 )/ SQL Server (2000/2005/2008 ) errors and failures, auditing activities, and resource utilization
• Designed, installed, configured, maintained patches, security, migrated, and upgraded Oracle applications 11.5.9/10 and Data Warehouse RDBMS 10g (Business Intelligence)
• Installed, supported, implemented, tuned Data mart (Oracle 9i), Informatica PowerCenter 6.1/7.1, Hyperion-Essbase System 9, MS SQL Server 2003 / MS SQL Enterprise Manager, Discoverer 10g R1/2
• Ensured consistent and reliable production activities, quality of existing and new applications, and execution of project schedules met all budget and time requirements