SUMMARY

• Over 6+ years of IT experience in Database Administration of MySQL, MS SQL Server and Oracle in production, development, test, Replication and Clustered Server Environments. 3 years of PostgreSQL Database Administration experience. Installation, Upgrade, Configuration and Administration
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting MySQL, SQL Server and Oracle databases.
• Experience in upgrading MySQL and SQL Server software to new versions and applying service packs and hot fixes and unattended Installation.
• Experience in Installing and Configuring MySQL Replication, Clusters and SQL Server Active/Passive clusters.
• Experience in working with Red Hat, Centos, SUSE, Ubuntu and Windows clients and Servers
• Backup and Disaster Recovery
• Implemented backup strategy based on the client needs and requirements; and in addition I assisted in performing proper restoration and recovery.
• Implemented various forms of replication in MySQL and SQL server environments based on company standards or client's needs.
• Implemented and utilized different backup tools such as mysqldump, Percona Xtrabackup and MySQL Enterprise backup based on company standards or client's needs.
• Implemented and successfully tested Database Mirroring and Log Shipping in SQL Server environments.
• Proactive Performance Monitoring and Tuning
• Monitoring of all the Critical Parameters for the MySQL database and responding to alerts and tickets generated by monitoring software's such as Nagios, Zabbix and other relevant scripts.
• Used show process list, the general and slow query log to capture and analyze queries with explain plan and make tuning recommendations when possible.
• Monitor the production server using tools like SQL Profiler, Windows Perform, Performance Counters and SQL server logs for Monitoring and Tuning SQL Server.
• Experience in MS SQL Server Configuration, Performance Tuning, Client - Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency

PROFESSIONAL EXPERIENCE

Sr. PostgreSQL/EnterpriseDB

Confidential, New York, NY

Responsibilities:

• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL/EnterpriseDB databases.
• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Experience designing database structures, indexes, views, partitioning.
• Implementing backup and recovery (Logical and Online).
• Setup and maintenance of postgres clusters utilizing streaming replication
• Performing schema management, database sizing, maintaining privileges.
• Extensive experience with Warm Standby (PostgreSQL 9.x and earlier), and Hot Standby (PostgreSQL 9.x and greater).
• Performance monitoring and optimization
• Installing and configuring Object level replication like Slony etc.
• Installing and configuring connection-pooling tools like Pgbouncer and pgpool etc.
• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios/zabbix etc.
• Installing and configuring Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Configuring log analyzation tools like pgfouine and pgbadger etc.
• Removing the Index bloat concurrently to improve the performance.
• Scheduled maintenance activities to vacuum, analyze to improve the query response time.
• Maintaining custom vacuum strategies at table and db level.
• Query optimization and troubleshooting of PostgreSQL/EnterpriseDB

Sr. MySQL/ PostgreSQL/SQL Server Database Administrator

Confidential

Responsibilities:

• Support of our Production database systems
• Configuration management of Database servers
• Recommends solutions by defining database security, and data back-up/recovery specifications
• Installs new systems and coordinating installation requirements
• Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products
• Prepares users by conducting training; providing information; resolving problems
• Provides information by answering questions and requests
• Maintains quality service by establishing and enforcing organizational standards
• Create and maintain effective documentation
• Provide on-call support with team as required
• Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications;
• Contributes to team effort by accomplishing related results as needed
• PostgreSQL DBA Duties
• Maintenance of PostgreSQL databases.
• Installation, Configuration and Upgrade of PostgreSQL databases on Linux
• Insured night cron jobs for backups, re-indexing & vacuuming & materialized views executed properly on 24/7/365 high availability Postgres production and development databases.
• Review all PostgreSQL logs for problems.
• Create Backup, Restore & Drop databases per developer's requirements.
• Implement Slony replication for Development, QA & Production databases.
• Respond to database outages caused by equipment failure and coordinate with Network Admin to perform database fail over to standby servers.
• Insure high availability of production via Slony replication.
• Propagate all database changes (DDL & DML) to multiple databases and servers.
• Optimize postgresql.conf for performance improvement.

Senior MySQL DBA/PostgreSQL

Confidential - Chicago, IL

Responsibilities:

• Participate and assist in numerous day to day MySQL database projects ranging from installations, upgrades and migration projects.
• Write Standard operating procedure documents and work with Linux administrators, Developers to architect and stabilize procedures for installations, upgrades, backups and tools to be used within the team.
• Assist in testing the written procedures and educate team on some of the written procedures and topics I have done research on.
• Work with manager on what procedure will be made standard based on testing and review.
• Help train and bring junior DBA's up to speed on standards and procedures.
• Database performance tuning of the MYSQL databases using native MySQL built-in and third party tools.
• Performed MySQL database upgrades and migrations.
• Backup design and disaster recovery plans and execution
• Ability to multi-task while maintaining high quality of deliverables supporting complex projects with complicated business drivers
• Participate in the writing, review and documentation of teams MySQL standard operation procedures for MySQL.
• Assist in the day to day support of MySQL databases for our clients.
• Downloading PostgreSQL, installing and performing service configuration
• Install and configure PostgreSQL 9.x(9.4/9.5) on RHEL/CentOS Linux
• Creating PostgreSQL databases, Tables and doing user adminstration/security by creating and deleting users
• Configuring PgAdmin and using it for managing the database server
• Backing up and restoring databases in PostgreSQL
• Setting up and configuring replication on master server and slave servers

MySQL/PostgreSQL/SQL Server Database Administrator

Confidential - San Antonio, TX

Responsibilities:

• Managing MS SQL Server and MySQL database installation and upgrade Projects
• Install, configure, upgrade, and migrate existing databases MySQL and SQL Server databases.
• Handled optimization of database performance worked with developers and system engineers to troubleshoot and optimize queries and performance bottlenecks for current and future products and services
• Assisted in formalizing and updating database policies, procedures, and technical standards, including disaster recovery planning.
• Oversee backup and recovery operations and wrote standard operation procedures for the installation, configuration and usage of backups programs and software such as mysqldump, Percona XtraBackup and MySQL Enterprise Backup.
• Wrote and Reviewed Common Vulnerabilities and Exposures Report for MySQL and used that to get approvals for patching/Upgrading MySQL.
• Wrote standard Operating documents for installing, configuring and architecting the MySQL environment, layout, directory structure that conforms to the optimal flexible standard for better performance.
• Performed data collection using various tools and used that to do capacity planning and performance tuning of the MySQL instances.
• Worked closely with development team, performed testing and report results and recommend software changes or design changes for approval.
• Monitoring MySQL and MS SQL Server using Zabbix and other tools.
• Installed, configured and migrated existing PostgreSQL databases.
• Automated DBA activities such as backups and upgraded existing PostgreSQL databases.
• Maintained and optimized PostgreSQL database application performance through tuning.
• Generated PostgreSQL database reports such as financial data statements and user data.
• Suggested latest PostgreSQL updates and evaluated database issues.
• Administered and troubleshoot PostgreSQL databases for critical problems.
• Implemented PostgreSQL system backup procedures and updated site resources.
• Developed PostgreSQL database architecture and environment setup and wrote numerous standard operating procedures.

MySQL/SQL Server Database Administration Sr. Advisor

Confidential - Atlanta, GA

Responsibilities:

• Utilize strong database administration experience and technical expertise for 24x7 monitoring and management of a large number of MySQL instances with large data sets as well as unique networking set-ups.
• Responsible for responding to support escalations which involve troubleshooting complex technical problems and resolving data/configuration issues within defined service level objectives.
• Provide strategic and thought leadership among peers on complex projects.
• Collaboration with peers in understanding new database technologies, assessing impact to security services operations, and proposing solutions to existing business problems.
• Collaboration in the software development lifecycle (SDLC) to develop detailed enhancement/bug definitions, write functional requirements, translate the requirements into solution designs, and navigate the functional requirements through to Production deployments.
• Proactively look for ways to create operational efficiencies as it pertains to the tools and technology used by Dell Secure works to support their customer base.
• Participate in, or directly work on any additional projects, assignments, or initiatives assigned by management.
• Create/maintain documentation for operational procedures.
• Document and perform system upgrades, application updates, and define monitoring requirements based on customer needs .Occasional shift work required.
• Participation in 24x7 on-call rotation required
• Install and configure PostgreSQL 9.x(9.4/9.5) on RHEL/CentOS Linux
• Backing up and restoring databases in PostgreSQL
• Setting up and configuring replication on master server and slave servers
• Suggested latest PostgreSQL updates and evaluated database issues.
• Administered and troubleshoot PostgreSQL databases for critical problems.