Summary
Overview
Work History
Education
Skills
Technical Summary
Timeline
Generic

Frank Pourmostadam

Summary

SQL Server DBA SME with over 18 years of IT experience, Managing 24x7 mission critical and enterprise class Database environment. Solid experience in Database tasks including installation, upgrade, tuning, DB security, backup and disaster recovery, etc. Experience with SSIS, SSRS and other Analytic and Reporting tools. Strong knowledge of High Availability and Disaster Recovery methods and technologies. Working knowledge of AWS and Azur Cloud Ecosystem support and migration. Knowledge of other database engines including MySQL, Oracle, PostgreSQL and MongoDB. Worked with broad range of Monitoring and DB Tools and Business Applications. A great team player with positive attitude and strong problem-solving skills. BSc. degree in Computer Software Engineering.

Overview

25
25
years of professional experience

Work History

Sr. SQL Server DBA

Bank of America
12.2022 - Current
  • Performed as SQL Server SME for all Database support activities.
  • Worked closely with application and IT teams to optimize all DB environments.
  • Ensured database performance, optimization, and availability.
  • Improved and supported production servers consisted of multi nodes with Always On availability group implementation.
  • Implemented and maintained HA and DR solutions for production environment.
  • Participated in meetings and design of a new project for Enterprise Data Warehouse that include Fact tables, Cubes, Data Marts and scripts for performing custom Extract Transform Load (ETL) environments.
  • Daily support for all DB related requests via chat and Jira tickets.
  • Reviewed and implemented SQL Server and database settings according with best practices.
  • Did POC on SQL to EC2 AWS Migration and performance benchmark.
  • Provisioned, Optimized and Maintained Azur and AWS Cloud databases.
  • Implemented and maintained SSIS and SSRS reporting tasks and Power BI for interactive reporting.
  • Reviewed and QA new database objects, managed bi-weekly code release, plus maintained existing databases design and trends.
  • Participated in on-call 24x7 support and on-call DBA rotation.
  • Environment included: SQL Server 2022, 2019, T-SQL, PowerShell, AWS RDS, Microsoft Azur, Power BI, SQL Sentry, AG/HA, SSRS, MySQL 8.0, Postgres 15.0, TDM, Gitlab, Redgate Backup pro, Idera SQL Diagnosis, Solarwinds, Grafana, BMC Portal, Lucid chart, Jira, Jenkins, Pager Duty, Rundeck and CD/CI pipeline.

SQL Server DBA

Rackspace
San Antonio, USA
02.2016 - 11.2022
  • Responsible for overall DBA support, including Installation, Tuning, Upgrade, configuration and 24x7 production support for All SQL Servers footprints.
  • Proactively reviewed and implemented SQL Server Tuning, response time improvement and keep documented up to date.
  • Supported and created complex reports and Data Cubes using SSRS and Power BI.
  • Worked with SSAS and SSIS and Microsoft Excel too.
  • Ensured all AWS / Azur and on-premises SQL Servers tickets were resolved with root cause analysis and in a timely manner.
  • Implemented and support HA solutions including Always-ON and Transactional replication in multiple production environment.
  • Implemented a new Disaster Recovery planning and testing.
  • Implemented SQL jobs to perform weekly business and analytic reports.
  • Monthly reviewed and optimized SQL internal, disk space, tempdb, transaction log usage and top queries and fixed it as required.
  • Configured server and database settings to improve performance.
  • Optimized complex queries using execution plan and ensured data integrity.
  • Wrote multiple stored procedure to serve business needs and audit SQL Servers.
  • Environment included: SQL Server 2019, 2017, Azur cloud, AWS SQL, Power shell, T-SQL, SSMS, SSRS Powershell, Superset, Redgate suite, SQL Century, Visual Studio, Microsoft Dynamics AX, Crystal Report, Oracle 19c, Quest Toad, Power BI and Biz talk.

DBA / SQL Developer

Informatica Inc.
San Antonio, USA
01.2014 - 02.2016
  • Managed and improved TB size high transaction SQL Server databases in Dev/QA and Production environment.
  • Designed and implemented database management systems by creating models, building table structure, establishing referential integrity, and preparing documentation; design databases to enhance existing applications; provided database support for application development lifecycle.
  • Participated in agile software development process.
  • Conducted overall servers’ health checks, fixed any slow performance and locking issues.
  • Independently was able to provide performance measures of transactional databases, identifying bottlenecks, disk analysis and other metrics to provide tuning recommendations.
  • Wrote SQL Server scripts to collect and analyze SQL Server Key Performance Indicators for any number of SQL Server Servers and databases to keep them safe and healthy.
  • Performed Request for Changes, RFC, on SQL Server Production Environments and I have applied massive changes in a couple of seconds for multi server environments.
  • Wrote technical detailed documentation on technology standards and procedures and make recommendations for optimization.
  • Environment included: Windows 2012/2014. SQL 2014, SSRS, SQL Century, BCP, Hadoop, NetBackup, Perfmon, Profiler, Tuning Advisor, Spotlight, Crystal Report, Rundeck, MySQL 5.x.

DBA

Bankrate Inc.
03.2013 - 01.2014
  • Administrated, managed and on-going support of all SQL Servers / 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.
  • 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: SQL Server 2012, SSMS, SSIS, New Relic, MySQL 5.x, .Net, SSMS, Backup Server Management.

DBA

Break Media Inc.
Burbank, USA
04.2010 - 03.2013
  • 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: SQLServer 2011, 2012, Server Backup & Restore, .NET Core, SQL Century, Redgate, Visual Studio.Net, VB.Net, C#, ASP.NET, Perfmon, Jira.

Developer / DBA

IBM
03.2010 - 04.2010
  • 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.
  • Prepared and planned DR strategy. Provided DB restoration services as needed.
  • Environment included: Windows 2010, SQL Server 2000, ErWin data modeling, Oracle 10g, Powershell, BCP, Informatica ETL, VB .NET, ServiceNow.

Programmer / Analyst

NCR company
03.2000 - 02.2009
  • Worked as Developer, performed back-end programming and some database management tasks.
  • Designed, implemented, 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.
  • Provided support for a CRM Application and Oracle Financial.
  • Designed and created various database objects to accommodate the development requirements for clients.
  • Implemented and tested several stored procedures as per business application requirements.
  • Environment included: Java, SQL Server 7.0, ERP, SAP, Windows scripting, IBM AIX, PL-SQL, SQL, C++, HTML, CSS, Oracle 8.1.

Education

BS.c - Computer Science

U. of Toronto
09.2000

Skills

  • Database management
  • Performance tuning
  • Disaster recovery
  • Data modeling
  • Cloud database provisioning
  • SQL scripting

Technical Summary

SQL Server 2022, SQL Server 2019, SQL Server 2017, SQL Server 2012, SQL Server 2008, Microsoft Azur SQL, AWS SQL, MySQL 8.0, MongoDB 5.x, MongoDB 4.x, PostgreSQL 15.x, Oracle 18c, SQL, PL/SQL, T-SQL, Powershell, Unix Shell Scripting, Python, Perl, AWS CLI, Windows 2023, Windows 2019, Windows 2015, CentoOS 9.x, RHEL 10.x, Ubuntu 22.x, HP-UX 10.x, HP-UX 11.5, SQL Century Tools, Idera Tools, RedGate, DataDog, RunDeck, HammerTime, ServiceNow, Jira, Git, Zabbix, New Relic, Navicat, LAMP, Agile, Scrum works Pro, Kafka, Docker, Kubernetes, Redis, Spark, Rational Rose, Host Explorer, PagerDuty

Timeline

Sr. SQL Server DBA

Bank of America
12.2022 - Current

SQL Server DBA

Rackspace
02.2016 - 11.2022

DBA / SQL Developer

Informatica Inc.
01.2014 - 02.2016

DBA

Bankrate Inc.
03.2013 - 01.2014

DBA

Break Media Inc.
04.2010 - 03.2013

Developer / DBA

IBM
03.2010 - 04.2010

Programmer / Analyst

NCR company
03.2000 - 02.2009

BS.c - Computer Science

U. of Toronto

Similar Profiles

CREATE PROFILE
Frank Pourmostadam