Experience Summary

An accomplished, results-driven Senior Cloud Database Administrator with 10 years of progressive experience in area of Database Management. Extensive Technical knowledge on Microsoft® SQL Server™ 2016/2014/2008R2 Management, Backup/recovery, Disaster Recovery, High Availability, Mirroring, Log-Shipping and Data Replication on homogeneous and heterogeneous system, DTS/SSIS, Capacity Planning & Performance.

AWS and Azure certified with extensive on premises to cloud migration experience.

Certifications

SQL Server Certifications

70-764 Administering Microsoft SQL Server 2016

70-462 Administering Microsoft SQL Server 2014/2012

70-463 Implementing a Data Warehouse with Microsoft 2014/2012

Azure Cloud Platform

70-535 Architecting Azure Solutions

70-533 Implementing Azure Infrastructure Solutions

Amazon Cloud Platform

AWS Certified Solutions Architect – Associate

AWS Certified Dev Ops Engineer – Associate

ITIL

ITIL Foundation V3 Certified

Professional Experience

British American Tobacco Sep 2019 – Present

Sr. Azure/AWS SQL Database Administrator

Responsible for providing business units with 24 x 7, enterprise support of database environments

EU Tax Compliance Systems

ERP and Data Warehousing

Responsible for providing corporate technical expertise on Installation, Administration, Performance tuning of

Microsoft® SQL Server 2019 Migration Planning and Deployment

Microsoft® SQL Server 2019 Availability Groups & Clusters

Microsoft® Cluster Server Windows NT 2016/2012

Microsoft® SQL Server 2017, 2014, 2012, 2008 R2

Enterprise implementation of Availability Groups, Data Mirroring, Log Shipping.

VMware Server & ESX, VMotion for HA

REDGATE SQL Compare, SQL Data Compare, SQL Clone

IDERA Diagnostic Manager & Quest Light speed

MYSQL 5.6 Administration

MYSQL Patching 5.6.27 to 5.6.30

MYSQL Replication setup (Master Slave)

Sybase 12.5 ASE Administration

Cloudamize Assesment Tool for Enterprise Cloud Migration

Azure PaaS and IaaS

Azure SQL Database as a Service Deployment, SQl DB and Managed Instance

Azure SQL DataWarehouse Deployment Synapse

Azure Geo Replication for HA and DR

Azure Cloud backups Recovery Vault

Azure Data Lake Storage

Azure Data Factory

Powershell 5 -7 Scripting

Experience using building infrastructure via CLI in an automated, repeatable manner

Azure Cosmos Mongo API Architecture

Cosmos Mongo Collection design and implementation

Cosmos Index design and maintainence

Azure Pipeline Configuration and Deployment

Azure Repo Configuration and Deployment

AWS Data Migration Services, Aurora on RDS and performing MySQL migrations

Aurora on RDS and performing MySQL migrations

PostgreSQL Deployment and Migration to AWS RDS

AWS Schema Migration Tool

Amazon Web Services: IAM, Directory Services configuration

Amazon Web Services: EC2, RDS configuration

Amazon Web Services: VPC, Direct Connect, Route53 Configuration

Amazon Web Services: S3, Glacier, Storage Gateway Configuration

Amazon Web Services: Cloudwatch, DataDog monitoring

Thorough knowledge of continuous integration tools (e.g. Jenkins, Udeploy)

Attunity ETL Data Replication to cloud environment

Data Center migration to Plano, New York for services expansion and DR. Migration of QA environment to Amazon Cloud (AWS), EC2 and RDS.

Setup, Installation, upgrade & migration of existing systems to SQL Server 2017 from SQL Server 2012/2008

Setup for disaster recovery, fail over strategy, High Availability of system using MS Clustering, Database Mirroring, SQL Always On, Replication and EMC SRDF solutions.

Support for (24 x 7) and problem solving using available resources & making presenting recommendations for

Co-ordination, co-operation, guidance and direction to group of DBA

T-SQL Code review and performance tuning recommendations to developers.

Involve in infrastructure design for its scalability of the system using MS Clustering, Database Mirroring, SQL Always On, Replication, load balancing

Database Maintenance and Troubleshooting

Error log monitoring for MSSQL Servers/ Replication Servers.

Database and Replication monitoring for optimal response and higher throughput using remote distributor

Database Backup & Recovery of databases

Security Audit’s and Compliance SOX.

Performance & Tuning of SQL Servers/ Replication Servers, Databases, systems, Networking configuration (optimal) and query optimization using SQL Query Analyzer/SSMS, Idera Diagnostic Manager.

Capital One Feb 2014 – Oct 2019

Sr. AWS/Azure SQL Database Administrator

Responsible for providing business units with 24 x 7, enterprise support of database servers in excess of 300.

Investment Database Production Support.

ERP and Data Warehousing

Responsible for providing corporate technical expertise on Installation, Administration, Performance tuning of

Microsoft® SQL Server 2016 Migration Planning and Deployment

Microsoft® SQL Server 2016 Availability Groups & Clusters

Microsoft® Cluster Server Windows NT 2016/2012 R2 64 bit

Microsoft® SQL Server 2016, 2014, 2012, 2008 R2

Enterprise implementation of Availability Groups, Data Mirroring, Log Shipping.

VMware Server & ESX, VMotion for HA

REDGATE SQL Compare, SQL Data Compare, SQL Clone

IDERA Diagnostic Manager & Quest Light speed

MYSQL 5.6 Administration

MYSQL Patching 5.6.27 to 5.6.30

MYSQL Replication setup (Master Slave)

Oracle 11g, 12c Database Administration

Mongo DB and Dynamo DB No SQL Administration

AWS Data Migration Services, Aurora on RDS and performing MySQL migrations

Aurora on RDS and performing MySQL migrations

PostgreSQL Deployment and Migration to AWS RDS

AWS Schema Migration Tool

Amazon Web Services: IAM, Directory Services configuration

Amazon Web Services: EC2, RDS configuration

Amazon Web Services: VPC, Direct Connect, Route53 Configuration

Amazon Web Services: S3, Glacier, Storage Gateway Configuration

Amazon Web Services: Cloudwatch, DataDog monitoring

Cloudamize Assesment Tool for Enterprise Cloud Migration

Azure PaaS and IaaS

Azure Database as a Service Deployment

Azure SQL DataWarehouse Deployment

Azure Geo Replication for HA and DR

Powershell 5 Scripting

Azure Cloud backups

Experience using building infrastructure via CLI in an automated, repeatable manner

Thorough knowledge of continuous integration tools (e.g. Jenkins, Udeploy)

Attunity ETL Data Replication to cloud environment

IBM Global Services for Capital One, Amgen, Honda Sep 2008 – Feb 2014

Sr. SQL Database Administrator

City National Bank Dec 2004 – June 2008

Sr. SQL Database Administrator

Bank of America Feb 1999 – Dec 2004

Sr. SQL Database Administrator

EDUCATION

University of Keele

BSc (Hons) Computer & Management Science

Contact this candidate