SUMMARY

• Experienced SQL System Administrator for over 7 years extensive experience in installing, configuration and administration of MS clustering. Extensively involved in 24/7 Production support of the databases, Microsoft Windows Active Directory Services administration, and round - the-clock database operations SQL DBA activities include but not limited to patch installs, capacity planning, backup and recovery of mission critical databases, Implemented a recovery plan to a point in time failure.
• Responsible for data security and Integrity with HIPAA requirements. Ability to troubleshoot day-to-day problems encountered on production as well as development database environments with SQL Monitoring services.
• Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes. Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, Log shipping, Database Mirroring, SQL Mail, SQL Scripting, Database Migration, Data Normalization, AWS Fed Ramp Services . Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment.

TECHNICAL SKILLS

• SQL server 2008/2012/2014/2016
• Windows 2008R2/2003
• Production & FQT, VB.NET
• Aqua data studio, SharePoint, Air watch, IBM, Blackberry Enterprise, JIRA, PowerShell, ETL Tools: SSIS, DTS, BCP.

PROFESSIONAL EXPERIENCE

Senior SQL Server Administrator

Confidential, Washington

Responsibilities:

• Extraction, transformation and loading (ETL) of data from various data sources (both internal and external) into client's analytical warehouse.
• Manage all SQL content, configurations, and search databases.
• Configuration of various analytical software that consumes our warehouse
• Fulfilling data requests from other departments
• Creating reports using SQL Reporting Services (SSRS)
• Installation, Configuration and Migration of SQL Server 2017/2016/2014
• Supporting applications that consume data warehouse & GIS services
• Maintaining the tuning, indexing and performance of our existing database infrastructure
• Using dynamic management views (DMV) and dynamic management functions (DMF), TSQL scripts, Triggers, and Store Procedure for troubleshooting and performance tuning that include finding out long running queries and query costs.
• Perform operational DBA duties: installation, database upgrades, patching, environment cloning, implementing backup/recovery and monitoring procedures, capacity planning, site failover/switchover, SQL Scripting, Database Migration, Data
• Performance tuning / analysis, troubleshooting and query optimization using native tools like MSSQL server profiler, activity monitor, performance monitor, event viewer, index tuning advisor, database tuning advisor (DTA), Dynamic Management views (DMV), services and protocols, and configuration manager.

SQL Server Administrator

Confidential, Washington DC

Responsibilities:

• Manage all SQL content, configurations, and search databases.
• Run transaction log backups to truncate logs.
• Create new content databases as needed.
• Create maintenance schedule for databases.
• Mirror data to disaster recovery sites.
• Patch the MS SQL Server and MOSS environments per ICE’s security baseline.
• Manage the SharePoint farm.
• Perform all farm level administrative tasks.
• Performance monitoring for SharePoint farm and all collections, sites, and content databases.
• Manage, create, deletion, backup, and restore site collections.
• Resolve farm and server level help desk requests.
• Data analysis, modeling, mining, forecasting, and extraction
• Conduct quantitative and qualitative reporting using data systems and summarizing findings and approvals in reports
• Windows Power Shell scripting (Create scripts to simplify procedures)
• Security planning and environment documentation
• Provides technical expertise in the use of database technology
• Create, deploy, and maintain baseline standards for server and workstation VM templates.
• Troubleshoot and resolve system hardware, software and connectivity Linux issues
• Evaluating, recommending, and implementing additional AWS solutions that will benefit the company

SQL Server Administrator

Confidential, FL

Responsibilities:

• Installation, configuration, operations, and maintenance
• Troubleshooting database issues
• Help configure and maintain storage solution for VMware administering Linux system-level procedures, establishing and maintaining administrator accounts, and assigning or making available file permissions. regular database patch and database upgrade
• Aid in administering enterprise applications that rely upon SQL Server databases.
• Tune performance of the environment including databases, tables, views/queries, and stored procedures.
• Install, upgrade, and configure SQL Server and related patches; perform all database maintenance, backup, and recovery activities.
• Develop and write stores procedures, functions, queries, and view in Transact-SQL as needed
• Set up and administer database security; provide user privileges in development, test, and production database.
• Perform operational DBA duties: installation, database upgrades, patching, environment cloning, implementing backup/recovery and monitoring procedures, capacity planning, site failover/switchover, SQL Scripting, Database Migration, Data implement data mirroring and replication to keep data live
• SQL Scripting, Database Migration, Data Normalization
• Experience using automation scripting tools like Power Shell
• Microsoft Windows Active Directory Services administration