Sql Server DBA

SQL Server DBA with * years of experience in SQL Server administration, Implementation and support. Hands-on experience in supporting SQL Servers `2000/2005/2008/2008R2/2012/2014 in investment banking, media, pharmaceutical, market research, and education industries. Offers solid track record based on professionalism, thoroughness, and dedication.

Able to work both independently and as a team player. Excellent communication, presentation and interpersonal skills.

Expertise on Production Server with Server Configuration, patch, upgrade, maintain complex and huge databases,and apply encryption to sensitive data.

Experience in Disaster Recovery Planning and Security Management operations.

Experience in HA Solution such as (WSFC) Cluster, Always ON, Replication, Mirroring and Log Shipping.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Maintained individual service accounts for SQL Server Services on cluster.

Migrated data between the two environments with SSIS and Import, Export wizard.

Experience in working in team as well as individual and writing documentation.

Designed data Partitioning solutions for tables and indexes & Risk Monitoring and control.

Experience to work with Development Team closely.

Created jobs, Alerts, Maintained plans to perform index de-fragmentation, reorganize index, rebuild index, and update the index statistics.

Implemented various Replication Models such as p2p, Merge, Transactional and Snapshot on basis of business specification.

Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.

Experience in using Performance Monitor, SQL Profiler and optimized queries, traced long running queries and deadlocks.

Certification:

Microsoft Certified Solutions Associate: SQL SERVER 2012/2014

Microsoft Certified IT Professional: Database Administrator 2008

Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and maintenance.

I have Passion for exceeding goals and targets.

I have analytical, research, and problem solving skills.

I have interpersonal and communication skills.

I am able to multitask and coordinate several projects simultaneously.

I can work well under pressure and with minimal supervision.

I am able to work both independently and as part of a team.

Must be able to address escalation items and conflicts in a timely, motivational and productive manner.

I am capable of quickly developing knowledge in other areas.

Professional Experiences

SQL Server DBA

PSECU - Pennsylvania State Employees Credit Union March 2015 to Present

Harrisburg, PA

Responsibilities:

Install and configure SQL Server Troubleshooting Performance issues and database issues.

Extensively worked on setting up Always On Availability Groups on a Multi-subnet failover network. Worked with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.

Install and configure latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers.

Design and implement comprehensive Backup Plan and Disaster Recovery strategies.

Maintain the database consistency by checking with DBCC Utilities at regular intervals.

Maintain Active/ passive and Active/ Active cluster environment with Virtual Machines using Hyper V.

Create and maintain Transactional, and Peer to Peer Replication environments.

Implement Database mirroring. Configured Principal, witness and mirror on the 2008R2 SQL Servers.

Used DMVS, DMFS, and SP_PROCS for the instant analysis.

Implement Asynchronous mode for Database mirroring in Staging Environment.

Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Implemented partitioning for both tables and Indexes.

Used Online Indexing and online Restoring in SQL Server 2008.

Applied changes on Production through Change management after thoroughly testing on development servers.

Successfully negotiated significant cost reductions with various vendors and utilities.

Experience in migration of databases from SQL Server 2012 to SQL Server 2014.

Involved in normalization of the Database in OLTP.

Installed, authored, and managed reports using SQL Server 2008 Reporting Services (SSRS).

Created SSIS packages to extract data from OLTP sources like MS SQL Server 2012, Text Files, Excel and Access to OLAP systems (SQL Server 2012).

Create documentation for steps that need to be taken while upgrading the SQL server 2008R2 to SQL Server 2012.

Environment: MS SQL Server 2012/2008R2/2005,Windows Clustering, Replication, Windows Server 2008R2 and Windows Server 2003, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 10g, LiteSpeed.

SQL Server DBA

SunTrust Bank, Virginia November 2013 to February 2015

Responsibilities:

Migration of databases from SQL Server 2008R2 to SQL Server 2012.

Installed SQL Server 2012 and configured Always ON with Primary and secondary Replicas, Read only databases, listener and with Application Intent.

Configured, tuned and maintained SQL server database servers.

Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects.

Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.

Deployed and uploaded the SSRS reports to Report Manager for the end users and involved in enhancements and modifications.

Monitored and modified Performance using execution plans with query hints and Index tuning.

Performance tuning of existing procedures and packages.

Creating views and basic stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.

Daily optimization tuning of a Bank Risk Management System including index tuning and query rewrites to apportion system resources

This project required extensive review and rewrite of stored procedures/ triggers, maintenance plans, troubleshooting SQL servers with enormous databases and implementation of Replication.

Performed horizontal data partitioning for efficient management of database tables and indexes.

Working on Client/Server tools like SSMS, SQL Server Enterprise Manager and Query Analyser to Administer SQL Server.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.

Working on different environments and a key resource for deployment of modified objects to production environments.

Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.

Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.

Incremental loading of dimensions, facts, error handling in SSIS.

Created Dynamic SSIS packages, to load Stage tables from text files.

Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.

Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.

Configured and managed virtual Servers and worked on virtualization and clustering environment.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.

Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Participated in IS Department and production meetings sharing knowledge for the development of the project.

Environment: MS SQL Server 2005, 2008 R2, 2012, Windows server 2003, 2008 R2, SAN, Visual Studio, DTS packages, SSIS packages, SSRS, Profiler, Index Tuning Wizard, ASP.Net Crystal Reports.

Environment: SQL Server 2005/2008R2 and 2012R2, SharePoint2007/2010, Windows Server 2003/2008 and 2012.

SQL Server DBA

Johnson and Johnson

Raritan, NJ September 2011 to October 2013

Responsibilities:

Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1TB.

Created and maintained various databases for Production, Development and Testing environments using SQL Server 2012, 2008r2.

Conducted Database mirroring in High Performance and High Availability mode and troubleshot issues with witness servers.

Transferred data from various data sources systems including MS Excel, MS Access, and flat files to SQL Server using SSIS. Created SSIS packages and scheduled the jobs to run automatically.

Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.

Performed daily backups and developed recovery procedures.

Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.

Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.

Implemented and configured database monitoring tools and focused on providing a high availability database.

Troubleshot issues with log file full and database size increasing beyond threshold.

Creation of new database, planning the location of data, index, and transaction log files on the disks.

Involved in web services SOAP and ODATA.

Involved in Capacity Planning, data modeling and Logical/Physical database Design

Handled the database components of application releases .

Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.

Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs

Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.

Leadership skills to build and guide Infrastructure and production support teams. Experience in working with global teams in onshore/offshore model.

Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.

Working experience HA solution like Logshipping,Mirroring,Transactional Replication,snapshot replication.

Environment: SQL Server 2014 / 2012 / 2008 R2 / 2008 / 2005 / 2000, T-SQL, Windows Server 2000 / 2003 /2008 R2 / 2012, .NET, Visual Studio, VMware Virtualization.

Technical Skills

Languages: T-SQL, POWER SHELL, HTML,

ETL Tools: SSIS and Remedy MDM.

Data Model: Darwin 2.0, Erwin, and SSAS.

Reporting Tools: SSRS, and Crystal Report.

Backup Software: SQLBackup, FTP, EMC, TDP and TSM.

RDBMS & Tools: SQL Server 2000/2005/2008/2008r2 and 2012, 2014, MS Access 2003/2007/2010, SQL Loader and Export/Import.

Operating System: Windows NT/2000/2003/2008 and 2008r2 /2012servers.

Third Party Tools: Red Gate, Spotlight, SCOM and IDERA.

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL,

SQL Server Management Studio and Enterprise Manager.

EDUCATION:

Master of Science in Physics

University of Rajshahi, Bangladesh

Bachelor of Science in Physics

University of Rajshahi, Bangladesh

CERTIFICATION EXAM:

EXAM

TITLE

70-461

70-461 Querying Microsoft SQL Server 2012/2014

70-462

70-462 Administering Microsoft SQL Server 2012/2014 Database

70-463

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

70-450

70-450 Designing, optimizing and maintaining DBA solutions using MS SQL Server 2008

70-432

70-432 Microsoft SQL Server 2008, Implementation and Maintenance.

STATUS: Permanent Resident

Reference: Available upon request

Contact this candidate