Sr. Postgresql/enterprise Db Resume
3.00/5 (Submit Your Rating)
New York, NY
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.
SQL Server/Oracle DBA
Confidential - Minneapolis, MN
Responsibilities:
- Participate in 24*7 on-call DBA support rotation and be flexible to work after hours for production needs as required.
- Work in a team environment to implement and manage database projects in a complex database environment.
- Work with System Engineering staff to develop standards for database architectures, coding standards, and quality assurance policies and procedures.
- Assists in designing and implementing redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
- Install and configure relevant network components to ensure database access as well as database consistency and integrity.
- Respond to and resolve database access and performance issues. Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
- Assist in managing and/or providing guidance to junior members of the team.
- Assist in planning and coordinating data replication and migrations between Oracle and SQL Server. Systems.
- Monitor, optimize and allocate physical data storage for database systems.
- Develop, implement, and maintain change control and testing processes for modifications to databases.
- Establish appropriate end-user database access control levels.
- Create, or support creation of, required reports in response to business user needs.
- Perform database transaction and security audits.
- Develop routines for end users to facilitate best practices database use.
Sr. MySQL/SQL Server DBA
Confidential - Portland, OR
Responsibilities:
- Designed, planned, and implemented database systems and programs.
- Administered several aspects of the project such as access methods, device allocation, Installation, configuration, backup and recovery.
- Provided technical assistance in identifying, evaluating, and developing systems and procedures as they relate to databases, replication setup and configuration and automated backups of such environments.
- Assignments included design of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.
- Configured systems for high availability by setting up native replication and Tungsten based replication.
- Ensured the health and performance of MySQL. Performance tuning included working on missing and unused indexes, query optimization, parameter tuning for the MYSQL server and Tungsten.
- Installed, configured, tested and managed Percona Server, Xtrabackup and Tungsten Continuent Enterprise in the Development, Test, and Amazon Cloud.
- Launched, created and managed Amazon EC2 instances and Installed MySQL and supplemental MySQL technologies such as Percona Server, Xtrabackup, and Tungsten Enterprise Replicator.
- Successfully experienced working in a team-oriented, collaborative and agile environment needing design for latest needs including elastic scalability with the ability to evaluate latest database products and deliver them into the Amazon Web Services cloud for testing before production.
- Scripted and tested automated backup procedures for MySQL and Tungsten environments and implemented them once successful by working with various teams.