Sql Aws

MOHAMMAD ZAKIR HOSSAIN

******************@*******.***

Ph. 347-***-****

Career Summary:

Over seven years of experience in database administration for databases in SQL server 2012,2014,2016 and 2017. Expertise in database administration on production server with server configuration, patch, upgrade, maintain and migrate databases.

Managed user permission and created databases, tables and various database objects based on business requirements. Created/Maintained and monitored indexes at regular intervals for better performance. Involved in database and log backups and restoration, planning backup strategies and scheduling. Expertise and proficiency in SQL server disaster recovery planning and security management operations. Experience on side by side upgrading SQL server lower version to the higher version. Expertise in T-SQL, writing stored procedures, triggers and functions. Experienced with high availability solution such as log shipping, replication, window failover clustering and always on. Experienced in data migration between the two environments with SSIS, detach/attach and export/import wizard. Strong experience in mentoring team members and writing documentation. Strong experience in working with Linux environment. Designed data partition solutions for tables and indexes. Strong experience in creating SQL server agent jobs, alerts, SQL mail agents and SSIS package. Experience in creating maintenance plans to perform index defragmentation,re-organize index,rebuild index and update the index statistics.

Experience in implementing different types of replication models such as peer to peer,merge,transactional and snapshot based on business specifications.

Experienced in performing integrity checks,methods include configuring the database maintenance plan wizard and DBCC utilities.

Expertise in troubleshooting SQL issues by using SQL tools like execution plans,statistics,index tuning wizard. Experienced in using performance monitor using SQL profiler and optimizing the queries,tracing long running queries incremental and full loading methods.

Setup EC2 instances in different subnets to manage and monitor SQL databases. and deadlocks.

Experience in creating different SSIS package using transformation methods,loading data to datawarehouse using Experience working on AWS and migrated mission critical databases to EC2 and RDS. Experience in using AWS Glue to move data from S3 to Redshift. TECHNICAL SKILLS :

● Operating Systems: Windows Server 2012/2016, Windows 10

● Database: MS SQL Server 2012,2014,2016,2017,2019

● Languages: T-SQL, PL/SQL

● Reporting/Migration Tool: SSRS (SQL Server Reporting Services), SSIS

● Data Modeling: SSDD (SQL Server Database Diagram), ERWin, RedGate, VISIO

● Other Tools: Remedy Ticketing System, JIRA.

● MS Office: Word, Excel, Access, Outlook and PowerPoint.

● Cloud: AWS

Education/Certification :

Bachelor in Soil Science,University of Dhaka.

Professional Experience :

Crius Energy, CT April 2018 – Present

SQL Server DBA

Responsibilities :

Providing 24/7 dedicated production support for SQL server problem resolution and server outages. Installed and configured SQL server 2017 and also applied cumulative updates and security fixes. Responsible for a large scale of database migration from SQL server 2014 to SQL server 2017. Experienced in migrating on premises database/legacy applications to AWS cloud ecosystem using Services like VPC, EC2, S3, EBS,EFS,EMR, RDS and REDSHIFT.

Responsible for creating T-SQL,stored procedures,table,views,functions,triggers and scheduling. Involved in database and log backups and restoration,planning backup strategies and scheduling. Rebuild the indexes at regular intervals for better performances. Verify backups and error logs on the servers and troubleshoot any failures or alert problems,and open trouble tickets if necessary to workwith technicians from other departments. Responsible for installing,configuring and maintaining SQL Always On .

/AWS Glue/AWS Redshift/S3/EFS/EBS.

Responsible for configuring and maintaining transactional replication in production environments. Involve in change management/incident management process and using Remedy tool notify requests and open new requests.

Involved in improving database performance using SQL profiler,SQL audit,execution plan,index tuning wizard and extended events.

Responsible for securing SQL server,user management and taking care of permissions and roles. Scheduling jobs and alerts using SQL server agent. Involved in creating SSIS package following different transformation processes and load to DWH using incremental and full loading process.

Department of Education, NY

SQL Server DBA August 2015 to April 2018

Responsibilities :

Installed,configured and administered SQL server 2014 and 2016. Backed up databases using FULL,DIFFERENTIAL and TRANSACTIONAL LOG back up methods. Restored database from database backups and file backups.Experienced with point in time recovery. Created SSIS packages to load all OLTP data to DWH both in full and incremental loading. Run DBCC statements to check physical and logical consistency of the database and rebuild indexes. Performed and monitored Database backups and other jobs in the maintenance plan restoration and point in time recovery.

Monitor server activity,Error Logs,space usage and solving problems as needed. Maintained server level,database level and object level security best practices by creating logins and users,configuring permissions,assigning different roles to users and creating encryption thru TDE. Created SQL server event,maintenance plans and performance condition alerts. Scheduled jobs to automate different database related activities including backup,monitor,database health,disk space and back up verification.

Set up Peer to peer replication on remote server.

Configured and administered log shipping.

Performed database integrity checks using DBCC utilities and maintenance plan configuration wizard. Implemented trouble shooting of SQL server performance issues using SQL tools,execution plans,trace,statistics,index tunning wizard.

Involved in creating events using SQL audit specification and extended events. Created,reorganized and rebuilt indexes and constraints. Performed database migration from 2012 to 2014.

Installed and applied service packs on SQL 2014.

Performed export/import of data and databases from/to flat file,excel file,SQL and Oracle to/from SQL server database and BCP.

Experience in creating,modifying tables and relationship management and views. Performed writing T-SQL,Triggers and Stored Procedures. Creating user accounts and appropriate privileges as well as maintaining database security. Performed tuning,maintaining and troubleshooting database problems. Virtue,NY

SQL Server DBA July 2013 to July 2015

Creating,Modifying tables,indexes(cluster/non-cluster),constraints(unique/check),views,stored procedures,triggers. Installed configured and managed SQL server in development,test and production environment. Configured log shipping as standby database from production database. Monitored database performance using profiler and engine tuning advisor. Database back up,restore and point in time recovery. Scheduled jobs to automate different database related activities including backups,history cleanups,monitoring database health,disk space and back up verification.

Developed different maintenance plans for database monitoring. Monitor server activity,Error Log,space uses and solving problems as needed. Upgrading SQL server and applied SP and CU from SQL server 2012 to 2014. Installed configured and maintained database mirroring using automatic failover option in SQL server 2014. Configured and maintained Merge and transactional replications. Creating SSIS package and load to DWH.

Contact this candidate