Sr. Database Administrator Resume
5.00/5 (Submit Your Rating)
SUMMARY:
Database administrator (DBA) with recent years hand - on experience on Vertica (BigData), NoSQL (MongoDB, CouchBase, Cassandra) and extensive experience designing, coding, testing and supporting next-generation database solutions in Oracle enterprise and SQL Server environments. Proficient in an assortment of technologies, including Oracle 9i/10g/11g, MS SQL Server 2008/2012, Windows and Linux /Unix platforms. DBA skills include: Specialties: Vertica 5/6, Hadoop, MongoDB 2/3, CouchBase 2/3, TokuMX, MySQL 5.x - 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 versionsPROFESSIONAL EXPERIENCE:
Sr. Database Administrator
Confidential, Palo Alto, CA.
- Maintaining a large deployment of database servers on a variety of complex and differing technologies, serving more than 1 billion transactions per day.
- . Reviewing schemas and queries on hosted database solutions
- . Optimize the implementations and develop best - in-class performance for the supported products.
- . Providing and implementing solutions for real time development and production tasks for existing and upcoming products.
- . Automating mundane database activities such as monitoring, backups and reporting.
- . Documenting the database procedures and policies for knowledge sharing.
- . Support various databases in terms of installation, configuration,upgrade, monitor, backup and restore: Vertica 5/6/7, MongoDB 2/3, CouchBase 2/3, Mysql 5.x, TokuMx, Cassandra, ElasticSearch, Redis
- . Responsibilities include configuration, provisioning, upgrading and decommissioning databases
- . Monitor production deployments for capacity issues, performance, troubleshooting and DB tuning
- . Actively participating in production database support.
- . Working with development team to verify and validate schemas and queries for performance and scalability
- . Providing guidance and suggestions for new and improved technologies.
- . Involve with other teams to migrate in-house applications to Google Cloud: GAE/GCS/Google-SQL
Sr. Cloud Database Administrator
Confidential, Newark, CA
- Installed, configured, monitored, and supported the following databases: MS SQL Server 2008 instances, Vertica 5.x, MongoDB 2.x, Hadoop for uptime, availability and functionality and ensure SLA's are met
- 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
- 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 Attended weekly team meetings and participate team building activities
Sr. Oracle / SQL DBA
Confidential
- 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