Sr. Database Administrator Resume Foster City, CA - Hire IT People

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.
Excellent experience in Installation and configuration of different databases on OS UNIX/LINUX and Windows
Planned and scheduled the Physical (Cold / Hot) backups as well as Logical backups for Oracle/MSSQL Server/MySQL/Vertica/MongoDB/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

PROFESSIONAL EXPERIENCE

Sr. Database Administrator

Confidential, Foster City, CA

Responsibilities:

Provide and design tools to assist in the management of the database and transaction processing environment.
Work to provide a working model of our transaction processing environment for capacity assessment and planning.
Develop a methodology for the ongoing assessment of database performance and the identification of problem areas.
Develop a security scheme for the database environment, as well as assisting in disaster recovery if necessary.
Provide 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.
Work 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.
Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
Support MS SQL Server 2014 (Always ON), MySQL 5.6, MongoDB 3.x, Postgresql 9.2 databases

Sr. Database Administrator

Confidential, Palo Alto, CA

Responsibilities:

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, MongoDB 2/3, CouchBase 2/3, Mysql 5.x, TokuMx, Cassandra, ElasticSearch, Redis
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
Involved with other teams to migrate in-house applications to Google Cloud: GAE/GCS/Google-SQL

Sr. Cloud Database Administrator

Confidential, Newark, CA

Responsibilities:

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 / SQL DBA

Confidential, Milpitas, CA

Responsibilities:

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

Database Engineer III

Confidential, Mt. View, CA

Responsibilities:

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