SUMMARY

• Over seven years of professional experience administering SQL server Databases including versions 2005, 2008, 2008R2, 2012, 2014 and 2016.
• Proficient wif T - SQL to create and update database objects like tables, views, stored procedures, functions, and triggers.
• Expert in reading and writing complex SQL queries utilizing subqueries and Joins.
• Expertise in SQL server installation, configuration, upgrade, and migration of databases.
• Implemented and maintained policies/procedures to ensure database security and integrity.
• Designed and implemented HA/DR strategy utilizing Maintenance Plan, SQL Server Log Shipping, Database Mirroring, Always On, and Failover Clusters.
• Implemented Replication including Snapshot, Merge, Peer-to-Peer, and Transaction.
• Expertise in database Performance Tuning, Index Management, and Update Statistics.
• Hands on experience in creating, updating, and executing SSIS packages.
• Expertise in troubleshoot SQL performance issues by using Execution Plans, SQL Profiler, Performance Monitor, Trace files, and Index Tuning.
• Identified SQL Server Locks, Blocks, and Deadlock situations utilizing System Stored Procedures, DMVs, and Activity Monitor.
• Experienced in creating Linked Servers between instances of SQL Server and Oracle/SQL Server.
• Familiar wif network/storage architectures.
• Great attention to details and excellent written/verbal communication skills.
• Experienced in supporting 24/7 on-demand applications.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003/2008/2012, Windows XP/Vista /7, VMware 10.

Databases: Microsoft SQL Server 2016/2014/2012/2008R2/2008/2005, Oracle 10g, Toad, MS Access.

Languages: T-SQL, PL/SQL, SAS, Java, VB Script, HL7, XML, HTML, and Powershell.

ETL/Reporting Tools: SSIS, SSRS, SSAS, Crystal Report.

Data Modeling: SSDD, Erwin, VISIO.

SQL Tools: MS Visual Source Safe, MS Baseline Security Analyzer, MS Visual FoxPro, Idera SQL Diagnostic Manager, Red Gate’s SQL Monitor.

Other Tools: SharePoint, JIRA, HIPAA, and BMC Remedy System.

MS Office: Microsoft-Word, Excel, Access, Project, Outlook, PowerPoint.

PROFESSIONAL EXPERIENCES

Confidential, Cherry Hill, NJ

MS SQL Server DBA

Responsibilities:

• Worked as part of both IT Operations and Systems Engineering (SE) teams.
• Installed and configured new SQL Server 2012, 2014 and 2016.
• Analyzed and Upgraded SQL Server 2005 and 2008 to 2012/2014, 2016.
• Migrated database from 2012 to 2014 and 2016.
• Developed and executed SQL scripts for database modifications like create or update—Tables, Stored Procedures, Functions, Views, and Triggers.
• Deployed database change scripts as provided by in-house developers or third party vendors.
• Applied SQL Server service packs and hot-fixes as they become available for updates.
• Scheduled maintenance tasks, planned production upgrades and capacity planning.
• Checked Database Health by using DBCC Commands and DMVS.
• Scheduled DBCC and update statistics on database to ensure data consistency and better performance.
• Implemented Database Backup, Restoration, and Disaster Recovery-procedures and performed Contingency plans testing.
• Configured and maintained SQL Server HA and DR solution including AlwaysOn, Failover Clustering, Replication, Log Shipping, and Mirroring.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Assisted developers wif code enhancements, tuning of queries and indexing teh tables.
• Performed Query Optimization, Debugging, Tuning, and Improvising performance of teh databases.
• Monitored memory, CPU utilization, disk utilization, locks, deadlocks and run-time of queries.
• Created/updated SSIS package, Import/Export utility, and BCP command to move data between different platforms.
• Utilized compression Techniques in SQL Server 2012/2008 R2 for backup and restore jobs.
• Documented teh organization’s database environment.

Confidential, Leesburg, VA

Database Engineer

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008,2008R2, 2012, and 2014 in development, test, and production environment
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008
• Configured and Maintained Replications, Log Shipping as part of a high availability solution
• Upgraded databases from SQL Server 2005 to 2008 in testing and production environment
• Applied SP (Service Pack) on SQL Server 2008 &2008R2
• Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Data modeling using Toad Data Modeler and Visio
• Installed and Configured SQL Server Reporting Services (SSRS)
• Generated Report using SSRS (SQL Server Reporting Services)
• Responsible for Database Backup, Restore and Point-in-Time Recovery
• Hardware requirements and storage capacity planning for Development, Testing, QA, Staging,
• Administer, maintain, develop and recommend policies and procedures for ensuring teh security and integrity of teh company’s databases and systems
• Monitored Server Activity, Error Log, space usage, and solving problem as needed
• Managed and resolved trouble tickets (Remedy) for database-related issues submitted.
• Designed DR database backup and restore plan.
• SQL Server performance statistics collection, Server monitoring and performance tuning.
• User account management and connection troubleshooting.
• Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
• Implemented and maintained database security, SQL Mail Manage small, medium and large SQL Server 2008 projects.
• Experienced writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Audited and generated monthly management reports using third party tool
• Created teh database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Promote/migrate SQL-Server objects from development to QA and QA to production instances
• Provided support to application developers in designing and implementing physical database structures.
• Implemented data models, database designs, data access
• Implemented security, generate and review report periodically and enforce security mechanism
• Maintained database integrity of all vendor and in house databases.
• Resolved and troubleshoot database issues, and perform upgrades, conversions and deployments.
• Proactively monitored teh production database(s) and optimize stored procedures for better performance; Resolve locking conflicts and resource utilization

Confidential, White Plains, NY

Database Administrator

Responsibilities:

• Installed and Configured SQL Server 2005, 2008, and 2012 in development, test and production environment
• Installed and Configured Operating System; Windows Server (2000, 2003 and 2008)
• Migrated databases from Oracle to SQL Server 2008R2
• Upgraded SQL Server 2005 to SQL Server 2008R2
• Migrated MS Access databases into MS SQL Server 2005/2008
• Closely work wif business analyst to deploy databases and manage availability
• Rebuild Servers (Restore & Recover) from backups
• Configured and Managed Log Shipping from Production to Standby Server (Running as Reporting Server)
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, and Clustering
• Wrote SQL, T-SQL, Triggers and Stored-Procedures
• Worked wif developers to tune-up performance of SQL and T-SQL query
• Performance tuning & optimization of servers in production, test environment
• Created and managed database security, data encryption, and applied object level security
• Developed and applied Backup strategy at my current workplace
• Setup and configured Database mail for notification purposes
• Developed Database Maintenance Plan for different important tasks
• Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs