Senior Mysql Dba/postgresql, Chicago, Il Resume
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.
- 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
- 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.
- 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
TECHNICAL SKILLS:
Languages: T-SQL, SQL, PL/SQL, HTML, XML, C# & Java
Scripting Languages: PHP, Bash Shell, Perl
Database Software: MySQL (5.1,5.5,5.6), Maria DB (5.1,5.5,10), Percona Server (5.1,5.5,5.6), SQL Server (2000,2005,2008,2012,2014)
Operating Systems: Oracle (9, 10g, 11g, 12c), PostgreSQL 9.4, 9.5
Linux: Red Hat & Centos(5,6,7), SUSE(10,11), Ubuntu(11,12,14)
Windows clients: XP, Windows 7, 8, 10
Windows Servers: 2003, 2008, 2012.
Network experience in Windows and Linux networks and great understanding of TCP/IP, LAN/WAN networks
Cloud Technologies: Amazon Web Services, Amazon RDS for MySQL, Amazon Aurora
PROFESSIONAL EXPERIENCE:
Confidential , Chicago, IL
Senior MySQL DBA/PostgreSQL
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
Confidential , San Antonio, TX
MySQL/PostgreSQL/SQL Server Database Administrator
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.
Confidential , Atlanta, GA
Sr. Advisor
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.
Confidential , Minneapolis, MN
SQL Server/Oracle DBA
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.
Confidential , Portland, OR
Sr. MySQL/SQL Server DBA
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.
Confidential , Minneapolis, MN
SQL Server DBA
Responsibilities:
- Implement and maintain SQL Server databases. Assist in the design of security and integrity controls. Design and analyze distributed computing policies, procedures, and standards. Patching and upgrading installations.
- Provide consultation to local lines of business and assist them with information technology decisions and implementations.
- Evaluate and research new information technologies and, when appropriate, recommend the implementation of new technologies to management.
- Perform daily database maintenance, monitoring, and performance turning tasks.
- Perform database changes based on the business and application requirements.
- Work with local and national lines of business to research, implement, and support information technology solutions. Develop and maintains project documentation.
- Create and update written documentation according to Federal Reserve project and information security standards. Provide management with written status reports for projects and tasks.
- Identify performance and scaling improvements of Database and document any necessary recommendations.
- Document and present any other findings or recommendations beyond those specified above
Confidential , Minneapolis, MN
SQL Server/MySQL Database Administrator
Responsibilities:
- Designed, architect, and build MySQL databases after determining business requirements in order to create logical models, building physical models, and plan system architecture.
- Experienced in designing, implementing, and managing MySQL database for high - traffic transactional systems.
- Performed MySQL installations on both windows and Linux/Unix based systems.
- Migrated/upgraded databases and applied MySQL patches.
- Supported MySQL in a 24x7 high volume production OLTP databases including development and quality Environments.
- Extensive knowledge of MySQL internals, replication and clustering including their setup, day to day management, monitoring and maintenance. etc.
- Configured and managed replication/standby instances of MySQL in local and remote data centers.
- Responsible for writing database-monitoring scripts, coming with best practices
- Monitoring MySQL and MS SQL Server using Nagios
- Used proactive approach to identify and improve databases performance.
- Used several tools for day to day management of MySQL: Navicat for MySQL, MySQL Workbench, MySQL administrator, PhpMyadmin.
Confidential , Dubuque, IA
SQL Server/Oracle Support Specialist
Responsibilities:
- Supporting SQL Server environments and ensuring high availability, performance, and security for the environment.
- Pro - actively monitor the database infrastructure to ensure secure services with minimum downtime.
- Perform troubleshooting and problem solving of the SQL Server environment.
- Perform implementations, patching, and release of database changes while following strict change control standards.
- Managing the internal and external MS SQL database security.
- As Oracle DBA provides physical database support in a multi-customer environment
- Scripting, installing and upgrading oracle 9i, 10G and 11g.
- Performed backups and recovery operations and checked backup reports on a regular basis.
- Operation and maintenance of Oracle database management software running on distributed platforms, using high availability solutions and load balancing.
- Wrote Documentation to help with daily task and routines.
- Help in training and mentoring Junior DBA staff.
Confidential , St. Peter, MN
Oracle/MySQL Database Administrator
Responsibilities:
- Installation, configuration and administration of MySQL RDBMS software.
- Managed backup and recovery processes including replication for failover environments as well as disaster recovery.
- Supported multiple system environments for development, testing and production.
- Monitored, diagnosed, and resolved database performance issues proactively.
- Controlled and monitored user access to databases and maintain database security.
- Participated in an on - call rotation with other operations DBA's.
- Planed, coordinated, and implemented security measures to safeguard computer databases.
- Modified existing databases and database management systems as required.
- Planned, coordinated and implemented security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
- Identified and evaluated industry trends in database systems to serve as a source of information and advice for upper management.
- Worked as part of a project team to coordinate database development and determine project scope and limitations.
Confidential , Norfolk, VA
Data Communications Analyst
Responsibilities:
- Installed SQL Server 2005 and performed upgrades.
- Create logins, users, and schemas in SQL Server 2005.
- Configure linked servers
- Created tables, adding constraints, and altering the tables.
- Created database views based on existing tables. Created online indexes which were mostly non - clustered indexes.
- Worked with XML data in SQL Server 2005 by retrieving XML data from a table, inserting XML data into a table, setting XML documents to use the xml type and creating an HTTP endpoint.
- Performed import and export of bulk data in SQL Server 2005.
- Perform management and monitoring tasks using the SQL Server Agent service which involved creating jobs, creating user-defined events, creating alerts and creating operators.
- Also checked and maintained database integrity in SQL Server by performing integrity checks on databases, manually shrinking databases, manually shrinking data files.
- Used SQL Server Profiler and System Monitor to monitor instances of SQL Server 2005.
- Created traces, monitored CPU usage, created alerts where necessary. Tuned SQL Server databases using Database Engine Tuning Advisor. Used the tool for tuning databases, viewing reports and implementing recommendations.
- Also used DMVs to look at the state of the server.
- Queried dynamic management views and functions and used them to view sessions, connections and requests.
- Performed detection and termination of transaction locks by tracking transaction locks terminating locks as needed.
- Connected to non-responsive databases using the dedicated administrator connection (DAC).
- Ensured greater protection for the database by setting up a database mirroring session which involved creating endpoints, creating logins and granting login permissions, creating a backup and setting the servers.
- Configure the log shipping options in SQL Server 2005 by enabling the primary database, configuring backup settings, enabling the secondary database and setting monitoring options. Configure replication and configure security by creating a Distributor, creating a Publication, creating a Subscriber and changing logins.
- Backed up a SQL Server databases by choosing a strategy and then backing up the databases. Also performed database restores in SQL Server 2005 by restoring the various databases and copying the databases between servers
- Performed several and multiple oracle installations identifying all the components to be installed and setting up the Oracle install using OUI, DBCA etc.
- Configured the Oracle Database 10g installation and performed installation on several platforms including Windows and Unix/Linux flavors such as RHEL4/5, CentOS 5.
- Used DBCA for database identification, management, password, and storage options of the various files and logical storage units. Also used DBCA to set file locations and parameters.
- Created, viewed and manipulated tablespaces.
- Administered user accounts by creating user accounts and profiles, granting privileges and assigning quotas to users, and creating a roles and assigning them to users.
- Implemented database security by making sure that users were authenticated via implementation of password security by configuring user profiles and restricted access to Oracle databases when needed.
- Used Oracle's Data Pump utility to export and import data. Used the SQL*Loader load data.
- Created and configure an Oracle Net Listener.
- Detected and repaired invalid and unusable objects such as indexes.
- Monitored performance using dynamic performance views, Enterprise Manager, and optimizer statistics.
- Used various tuning and diagnostic advisors and use the segment advisor to detect storage problems including managing the AWR and using the ADDM to review database performance. Configured several databases for proactive maintenance.
- Managed lock conflicts by detecting and resolving lock conflicts.
- Configuring and managing databases for backup and recovery.
- Used the RMAN command line to create and manage basic and advanced backups.
- Set the listener passwords and specified who can access a databases. Improved the security for external procedures. Tightened security for the Oracle 10g listener.
- Created and used database links and transactions; and viewed information about them.