`

Frank Pourmostadam

ad3ouj@r.postjobfree.com

310-***-****

Sr. MySQL DBA

Professional Summary

20+ years of experience in IT sector, 8+ years as MySQL Database Administrator Managing multiple Mission Critical, Enterprise class Production environment, on-premises and on AWS RDS Cloud.

Wide Experience on other database engines and technologies as well like PostgreSQL, RDS, Microsoft SQL Server and MongoDB Atlas.

Solid knowledge of database support tasks including Installation, Migration, Upgrade, Troubleshooting, Advance Performance Tuning, Space Management and Query Optimization.

Well verse on Agile Technology, incident management, problem management process & compliance process, have strong business knowledge and abilities to build strong customer relationships.

Experiences with large TB dataset production, OLTP and DSS applications, Design and Managed complex HA Solutions and advance tuning for maximum uptime and responsiveness.

Worked with Broad range of Monitoring and Database Tools and variety of Business Applications.

Reliable Team player with a positive attitude and ability to work independently.

Strong problem-solving skills and passion to always learn new topics and technologies.

BSc. degree in Computer Software Engineering.

Technical Summary

Database Systems:

MySQL 8.x, 5.7, 5.6, 5.5, MariaDB 10.x

AWS RDS, AWS Aurora

SQL Server 2019,2016, 2012

MongoDB 6.x, 5.x, 4.x

PostgreSQL 10.x, 11.0

Database Tools:

Percona Tools, XtraBackup, pt-query-digest

Zabbix, DataDog, New Relic, Nagios, Cacti.

Mongo Atlas, Data Lake, SSMS

Elastic Search, Redis, Memcached, Solr, CommVault

MONyog, MySQL Enterprise Manager, MBU. MMM

RunDeck, Embarcadero DBArtisan, SolarWinds, Spotlight for SQL

Informatica ETL, IBM Tivoli, CA Erwin, Scrum

Languages:

SQL, PL/SQL, T-SQL

Unix shell scripting, Windows batch programming, Pyton, Perl

PHP, Perl, JAVA, Visual Basic, C++

Operating System:

CentoOS 7.x, 8.x, RHEL 7.x, Ubuntu 14.x

Windows 2018,2003/2000/NT/AA

Solaris 2.x, 8.x,10.x

HP-UX 10.x, 11.5

Other Software:

Git, Docker, All Cloud Services

Agile, Scrumworks Pro, SPL, LVM, Veritas Cluster Monitor

MS Project, MS Office, J2EE, JDBC, Jenkins,

Total-e, ManageNow, SmartFTP

IBM WebSphere, Clarify, PVCS, CVS

Rational Rose, Host Explorer, MKS Toolkit

CAREER HISTORY

Date, Company,

Job Title

Duties and Responsibilities

Dec. 2020 – Present

Sr. DBA

NBC Universal

Los Angeles, CA

Worked as SME and senior member of Database Support Team for over 250+ Production/QA/Dev MySQL as well as Cloud AWS servers.

Provided expert insights and solutions and advises for any data related tasks.

Designed, Managed and successfully implemented various Optimization, Migration and High Availability projects, involved in the whole process and multiple meetings.

Designed proper Replication topology, worked with multiple versions of MySQL,

On-Time Troubleshoot and Document any Database issue and root cause analysis.

Supported NoSQL database performance, replication topology and failover

Worked with very large high traffic dataset and high availability options.

Involved in Cloud Database Best Practices, RDS, Aurora setup and all AWS components related. Worked extensively with CloudFormation scripts and CLI commands.

Prepared runbook and how-to documentation and performed Knowledge Transfer (TK) to other teams and members as required.

Support clients with SQL Servers, Azur Cloud, Couchbase and MongoDB instances as well.

Prepared and planned DR strategy. Provided DB restoration services as needed.

Resolved daily tickets and DB requests, achieved customer daily calls satisfaction.

Working with database sizes that vary from 10+ GB to 2TB, on-time Support and Troubleshoot for Production/QA Servers on-premises and on Cloud.

Environment included: MySQL8.0, 5.7, Percona 5.x, AWS Aurora/RDS, Scrum, Agile, Mongo DB 5.3, DataDog, Git, Jira, Linux CentOS,9.0, PosgreSQL,Percona Tools, Galera Cluster, XtraDB Backup, ServiceNow, Syslog, Magento. Bash, PowerShell, Python, Perl scripting languages, Solr, New Relic,Zabbix, Monyog, PagerDuty, ServiceNow.

Feb. 2016 – Dec. 2020

Sr. DBA

RACKSPACE Inc.

San Antonio, TX

Managed and maintained all corporate MySQL/MariaDB Infrastructure (Prod/QA/Stage/Dev), Performed day to day support in a high traffic DB environment.

Developed and maintain SQL queries, Stored Procedure, Functions etc for various application needs.

Configured HA solutions, MMM wrapper, various single/multi-source replications on database/table level and setting db parameters and ElasticSearch.

Setup automated monitoring and alerting for all database systems.

Setup automated backups for production environment, perform DR and PITR.

Involved in MySQL migration projects from on-permise to Cloud and of from AWS cloud to new Datacenter as well.

Setup and control user security and usage privileges, Harden production servers.

Collaborated with various teams and guide them on best practices.

Managed Query Optimization and Index Fine Tuning, optimizing database performance and ensure data integrity

Performed Galera Cluster installation and config with optimal write anywhere solutions.

Wrote automation scripts using bash, Perl and Python.

Environment included: RHEL 7.x, CentOS 7.x, MySQL 5.x, MariaDB 10.x, Percona MySQL 5.7, AWS (RDS, Aurora,Redshift), PosgreSQL, HammerTime, Percona XtraDB, ServiceNow, Jira, Syslog, Magento., Python, Perl scripting language, Percona Tools, XtraBackup, PMM, pt-query-digest, RunDeck,Jira, NewRelic.

Jan. 2014 – Feb. 2016

Sr. DBA

Informatica

Redwood City, CA

DBA resource and team’s SME for all MySQL and Database related request and projects.

Supported all existing data infrastructure in several database environments, architect systems for scalability, reliability, and performance.

Develop and optimize physical design of MySQL database systems.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.

Planned database patching and upgrade to MySQL 5.6 for the CRT application. Design and test a new Cluster-based master-slave MySQL solution for the database layer to make a highly available fault-tolerance platform.

Involved in completing the design and Runbook documents for in-house application.

Implement and support MySQL RDS, read replica and hot standby AZ, import the data from old database to RDS. Configure and Tune my.cnf and security groups.

Keep track of production changes and note them in Remedy force tool.

Modified and scheduled monitoring scripts through cron, using Python, Powershell and bash.

Environment included: Redhat Linux, MySQL 5.x, MySQL NDB, Bash scripting, MySQL Enterprise Manager. Percona XtraDB, Amazon Cloud Services, Redshift, RDS, EC2, RemedyForce, Jira, Scrum, Syslog, Cloud Real Time, F5 load balancer, Nagios, Box, Puppet, Chef, Scrum, Java, Python, Cron job.

Mar. 2013 – Jan. 2014

DBA consultant

Bankrate Inc.

Palm Beach, FL

Administrated, managed and on-going support of all MySQL Production/QA/Dev databases servers required for various company projects and web applications.

Diagnosed and troubleshoot daily issues in production servers, performed systematic analysis on OS, Server, Database and Application as required, document the solutions and root-cause analysis.

Implemented and support of several MySQL replication setup including Multi-Master, Master and multi-level slaves.

Setup proper Backup and recovery strategy performed recovery exercise and prepared DR documentation.

Supported existing data infrastructure to manage data in several database environments

Architect systems for scalability, reliability, and performance.

Proactively conducted performance tests, identify bottlenecks.

Performed root cause analysis on failures. Resolved performance tuning related issues, reports, and queries.

Performed periodic review and confirm database security controls are correctly implemented

Created and reviewed database metrics for capacity planning, performance tuning, and operational efficiencies.

Environment included: CentOs 5.x/6.x, Windows 2003/2008,2012, MySQL 5.x, SQL Server 2012/2008, Idera Diagnostic, WUG, F5 load balancer, Akami, Nagios, Gomez, mRemote, Navicat, phpMyAdmin.

Apr. 2010 – Mar. 2013

MYSQL DBA

Break Media Inc.

Los Angeles, CA

Performed database monitoring, maintenance, reorganizations, resource management, schema management, and capacity planning and performance tuning for the databases

Diagnosed and troubleshoot daily issues in production servers, performed analysis on OS, Server, Database and Application.

Involved in installation, configuration, new and upgrade servers, setup various replications.

Provided support for application developers regarding design and implementation of physical database structure and schema design.

Reviewed and approved new database objects, managed weekly code release, maintained existing databases design and trends.

Handled on-call and after hours support as required.

Worked with large OLAP system, managed and optimized structure and total response time.

Environment included: Ubuntu 13.x, 14.0, Windows 2003/2008, MySQL 5.x, SQL Server 2012/2008/2005, Opsview, Zabbix, phpMyAdmin, SVN version manager.

Mar. 2009 – Apr. 2010

MySQL / SQL DBA

IBM / CDI Consulting

Los Angeles, CA

Performed all database administration activities to support all phases of development, testing and production.

Designed, developed and deploy data systems on a regular basis.

Setup Cacti, Nagios and other administration and monitoring tools and investigated new tools and technologies to improve and facilitate database server administration.

Worked closely with developer team. Provided DBA guidelines on queries and db objects

Handled after-hours support on rotation basis, respond to emergency situations on conference-call and individually.

Supported MySQL replication servers for Test and Production environment, applied the best practice and document the tasks.

Managed routine code release, applied hot-fixes, deploy codes and db objects to Production servers after sign-off review.

Environment included: Ubuntu 10.4/11.2, CentOS 5.x, 10.x,11.4, Windows 2003/2008, MySQL 5.x, SQL, Bash, Perl, Nagios, Cacti, Jenkins, phpMyAdmin, vmWare, Xen Center, Cloud Computing, SQL Server 2005, 2008, SVN, Apache, LAMP, Percona Toolkit/Xtrabackup, Hive/Hadoop/Squoop, MySQLTuner. Webestrino, Wordpress

Feb. 2007 – Feb. 2009

DBA / Developer

State Street Inc.

Irvine, CA

Administrated and supported over 100 large and medium size MySQL and SQL Server database servers, tasks included troubleshooting issues, proactive db monitoring, system restore as required, managed objects and users, query tuning and on-call support.

Wrote codes and scripts for data transformation purpose. Maintained business related scripts and sql codes.

Setup Linux boxes, MySQL Replication server, dual-master, master with multiple slaves, continue to maintain, tune, troubleshoot and documented the servers.

Implemented several automated database monitoring bash scripts and database alerts.

Maintained database models and track changes.

Worked with other team members, project manager, developers and clients, response to database related issues. Participated in several meetings every month.

Evaluated and installed third-party tools, prepared related technical documentation for executive.

Environment included: Windows 2003/XP, HP-UX 11.5, CentOS 4.x, Red Hat Linux 8.0, MySQL 5.0/4.1, SQL Server 2k/2005, SQLyog, TOAD 8.1, ETL, ERWin, ActiveReport, MS Visio, MS SourceSafe, WhiteSand Monitoring Tool.

Oct. 2002 – Dec. 2006

DBA / SQL Developer

IBM Canada

Toronto, CANADA

Provided 24x7 DBA technical supports to team and clients, ensured smooth operation of all corporate databases and maintained the database environment.

Documented and maintained new servers and performed code review and release.

Designed and implemented a reporting data warehouse/data mart application

Participated in DR of Cluster-based SQL Server 2000 system.

Integrated and implemented RMAN backup with IBM Tivoli manager tools.

Wrote codes and scripts for ETL processing of legacy systems to new repository.

Coded customized SQL scripts for an in-house financial system.

Supported project management requirements as product delivery schedules, resource estimates, personnel assignments by working with customers, suppliers, and vendors.

Developed and maintained shell scripts and sql codes and setting up of the cron job.

Search for tuning opportunities in current configuration and made changes as required.

Environment included: Windows 2000/AA, Sun Solaris 7.0, Oracle 10.x/10g, Clustered SQL Server 2000, MySQL 4.x, PL/SQL, OEM 2.0, RMAN, IBM Tivoli, DB Artisan, SQL Navigator, ManageNow, Lotus Notes 7.0, PVCS, Carbon Copy.

Apr. 2000 – Sept. 2002

Developer / Data Analyst

SOLCORP INC.

Toronto, CANADA

Designed and implemented a PL/SQL interface for extracting billing cycle from CRM Application and feed into in-house Web Application on a monthly basis.

Ensured and maintained stable uptime of databases and optimized database response time and query tuning.

Defined and implement security and access policies to ensure security of databases.

Designed and implemented automated scripts to perform routine database tasks.

Managed schema versioning using Oracle Designer and performed schema upgrades.

Reviewed company enterprise data model prepared logical and physical models.

Provided DBA support for a CRM Application and Oracle Financial.

Performed capacity planning to project future hardware and software needs

Optimized SQL queries, tuned overall application performance

Provided 24x7 technical support for Database and application related issues.

Environment included: Windows NT 4.0,2000, HP-UX 11.0, Oracle 8i, Oracle Designer, SQL Server 7.0, Oracle Financial 11.0, OEM 2.0, Unix Shell Script, PL/SQL, Java, XML, IBM WebSphere, IBM Visual Age, Host Explorer, SmartFTP.

Mar. 1996 - Jan. 2000 Programmer / Analyst

I.A.C (NCR Company)

Worked as Developer also DBA team member, performed back-end programming and some database management tasks.

Designed, programmed and tested City Population Code sub-system. Integrated into National Registration Application.

Implemented changes to data, data structure and business processes, including Database Infrastructure related documentation.

Created, relocated and cloned Oracle instances. Migrated between different Oracle versions.

Participated in the design & implementation of logical/physical database modeling process

Designed and created various database objects, including tables, indexes, triggers, stored procedures and etc. to accommodate the development requirements for clients.

Implemented and tested several stored procedures as per business application requirements.

Environment included: Windows NT, VAX VMS, AS/400, MF Cobol, SQL Server 7.0, Sybase 10.5, PL/SQL, SQL, C ++, Visual Basic, Ms Office, TelNet and MS-Access 2000.

EDUCATION AND QUALIFICATIONS

Schools & Dates

Qualifications

University of Tehran

Sept 1992 – Dec. 1996

BS.c degree in Computer Software Engineering

Courses:

Advance MYSQL for Database Administrators

Database Advanced Tuning

MongoDB / PostgreSQL Administration

Contact this candidate