SUMMARY:

Exceptional DBA skills over 5 years of experience and US permanent resident looking for a SQL Server Database Administrator Position.

KEY SKILLS INCLUDE:

• Backup/Recovery
• SQL server Installation and configuration
• TDE
• CDC
• Design and implement and maintain SQL Jobs and Alerts
• Database security
• Database performance Tuning
• Create and maintain Databases and Database Objects
• T - SQL
• Hardware Troubleshooting
• SQL Server Administration
• Database upgrade and migration

TECHNICAL SKILLS

Database: SQL Server2016, 2014 2012, 2008 R2.

SQL Tools: Idera (SQL Server Diagnostic Manager, SQL Safe),, RedGet (SQLCompare, SQL Data Compare), SQL sentry performance monitor, Solarwind

Version Control: Microsoft Team Foundation Server, SQL Source Control, Share point

ETL Tools: SSIS, (SQL Server Integration Services )

Reporting: SSRS (SQL Server Reporting Services/Server)

Scripting Language: TSQL, PowerShell, .Net.

Operating System: Windows Server 2003/2008/2008 R2/2012 R2, Windows XP

Hardware/Storage: EMC 5200

Networking: Active Directory

Environment: Agile mythology

Web Application: Share Point foundation, Share point enterprise

Ticket track system: Freshdesk

PROFESSIONAL EXPERIENCE

Confidential - Washington, DC

SQL DBA

Responsibilities:

• SQL Server 2016, 2012, 2008 (SSRS, SSIS) installation.
• Troubleshoot with different types of error occurred during installation.
• Instant file initializing, proper allocation unit for system drive and other drives.
• SQL Server 2008 to 2012 and 2014,2016
• SQL Server 2008R2 to SQL Server 2016
• Physical server to VM ware.
• Standalone to Active/passive Cluster (By consuming Old DNS name and IP Address)
• Written T-SQL, Trigger, and Stored-Procedures
• Assisted application, web and database developers to optimize SQL queries, Stored Procedures, functions etc.
• Maintain a change control process. Guide developers through new SQL code deployment to Dev, QA and Production environment. Tool use - TFS, SQL compare, Service Desk.
• Exported data from SQL Server to multiple destinations .
• Create and managed MS SQL Cluster (Active/Passive), Multi node cluster on Cisco UCS blade chassis 5100 series, shared storage on EMC VNX 5200 Series.
• Installed, Configured and Maintained SQL 2012 Database Mirroring (High Safety) using automatic fail-over option (Multi database, Agent Job) for Database warehouse
• Configured and troubleshooting Replications (Transactional).
• VISIO, SQL Server Data Diagram
• Applied SP (Service Pack) on SQL Server (2016 and 2012) and Windows Server (2012,2008, ).
• Cluster aware update for windows servers 2012 R2.
• Applied HOT Fixes, Cumulative update on SQL Server (2008, 2012, 2014,2016)
• Strong knowledge on database Monitoring and Performance tuning.
• Monitor different logs, Space usage, Events, Agent Job history by PowerShell scripts.
• Provide support to application developers in designing and implementing physical database structures.
• Tune slow running, resource consuming queries by evaluating query execution plan.
• Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve deadlock, block, and locking conflicts and resource utilization.
• Idera Backup solution - SQL SAFE.
• Familiar with EMC Recovery Point techniques.
• Strong working experience in SQL native database Backup and restore.
• Disaster Recovery planning and implementation.
• Experienced with Point-in-Time Recovery.
• Take necessary prevention for data corruption.
• Strictly maintain data integrity using DBCC CHECKDB.
• Restoring single page from backup using dbcc write page, dbcc ind.
• Documentation: Prepare different documentation (SQL Server Build Guide, Database Decommissioning steps, restore steps,) and update them in timely manner.
• Encryption: PCI complacence by using SQL Compliance from Idera, SQL auditing.
• Change data capture .

Confidential - Utah

Database Administrator

Responsibilities:

• Monitoring and maintenance of databases, installation of database software upgrades, monitoring of database backups, standardization and implementation of databases to improve the management of production and test environments, physical database design
• Documentation of standards and procedures, assistance to application developers, backup and recovery and consulting
• Support users by resolving problems with applications databases.
• Configured and maintain replication technologies that are used to support MSSQL to include log shipping, transactional, and snapshot replication
• Experience with third party replication technologies to include Vision Solutions
• Successful implementation of service packs and version upgrades for MSSQL
• Experience with the creation of backup scripts and the various backup strategies that are provided by Microsoft SQL Server
• Wrote and executing Data Manipulation Language (DML) scripts for Microsoft SQL Server
• A basic understanding of executing power shell scripts and as they related to MSSQL is required
• Developing, producing, and reporting metrics on database performance and health
• Responsible for data loading, security, performance monitoring and tuning, capacity planning, and backup and recovery
• Database performance fine tuning and optimizing poorly performing queries, stored procedures
• Producing database metrics using SQL Management Studio as well as the creation of custom scripts
• Configured operating in Windows Server 2008 R2 hosted on a virtual platform such as VMware
• Work independent in a team oriented environment and have excellent communication skills