We provide IT Staff Augmentation Services!

Sql-server Database Administrator (lead Sme) Resume

PROFESSIONAL SUMMARY:

  • I enjoy employing leading edge technologies and advanced design configurations in developing the project solution.
  • I bring a host of technical experience including application support in VB.NET and scripting, working closely with Windows Server/Systems Administrators in the Windows Server 2012, 2008 R2, 2003 and SQL Server 2014 back to 2000 environments implementing and managing clustered servers. Now I add to my support offerings, datacenter - class server-level enterprise hosting administration.
  • Expert experience in high-availability production environments.
  • Extensive experience in virtual machine technology solutions.
  • Expert experience in failover clustering installation, administration and support.
  • Experienced in administration of large number of machines SQL Server farm - datacenter.
  • Extensive experience in enterprise/datacenter disaster recovery operations.
  • Extensive experience in creating and working problem tickets with Microsoft to successful resolution.
  • Experience in large database management and manipulation - 500GB to over 10TB.
  • Expert experience in database administration and Microsoft database technologies.
  • Experience in data modeling and normalization techniques
  • Experience developing in Microsoft VSTS 2008,2010,2012 / TFS and Embarcadero ER Studio data modeling
  • Experience in T-SQL Scripts and Trigger development
  • Experience in database tuning utilizing SQL Profiler, Database Engine Tuning Advisor, PerfMon, Performance Dashboard
  • Experience in n-tiered client/server computing technologies
  • Experience in data warehousing technology
  • Expert in fundamental database administration and security
  • Experienced in interfacing with archival backup systems, i.e. Commvault, Networker, DPM, also SCOM
  • Maintained high availability of the customer’s data
  • Performed tuning and optimized performance throughput the solution as it pertains to the architecture of the system or platform.
  • Monitor the database’s health and performance. Server and application level database administration.
  • Knowledge of data communications and network infrastructure
  • Expert in setting up maintenance plans, creating jobs, database mail.
  • Expert in E.T.L TOOLS (S.S.I.S, B.C.P, Import & Export Wizard).
  • Expert in SSRS

PROFESSIONAL EXPERIENCE:

SQL-SERVER DATABASE ADMINISTRATOR (Lead SME)

Confidential

Responsibilities:

  • Working With Department of Defense, Veteran-Affairs, Leidos, Customers on Government deliverable Projects
  • Ensuring Right privileges and permissions in Production, QA, Test & Dev Environment. Including NIST & Non-Nist Boundaries/ DIACAP & Non-DIACAP.
  • Migrating Databases from Sql 2000 to Sql 2008R2
  • Migrating Databases from SQL 2005 to SQL 2014.
  • Migrating User logins with/without Password from Old Instance of Sql 2000 to Sql 2008R .
  • Working with the Application Team to determine if their applications work with the new compatibility mode.
  • Updating Statistics, Rebuilding Indexes on New Server (Index-Optimize).
  • Performance Monitoring, Tuning.
  • Deployment of OEM Monitoring Tools(Oracle) for SqlServer
  • Migrated Microsoft Access Database to SqlServer
  • Resolved Cluster Related errors on Windows Server 2003 & Legacy versions of SQL-Server.
  • Created a Monitoring Dashboard for Monitoring the Enterprise by creating an effective alerting system which prompts when SQL-Server restarted with the downtime, and active node if applicable.
  • Ensuring CPU Load-Balancing after Maintenance Window for Server Patching. Resources are being failed over to secondary nodes during server patching, and prior to Production Hours, I verify that all resources are running on their primarily assigned nodes.
  • Updating SQL Server Instance patching with the latest Service packs & OR Cumulative Updates.

Confidential, VA

SQL-SERVER DATABASE ADMINISTRATOR

Responsibilities:

  • Microsoft SQL Server DBA with 10+ years of experience in design, Development and Administration using MS SQL Server 2008, 2012 database environments.
  • Extensive experience on both SQL Server Administration and T-SQL Application Development
  • Knowledge of Normalization/ Denormalization techniques for OLTP and OLAP environments.
  • Used SQL Indexes for improving query performance, lower storage and maintenance cost.
  • Experience in optimization tools such as SQL Profiler, Dynamic Management Views (DMVs)
  • Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
  • Hands-on working experience in Installing, configuring, upgrading and managing SQL Server 2008/2012 and upgrading Service Packs for multiple instances.
  • Good experience in user management for DBs, maintaining of databases, and providing SQL
  • Server security by assigning logins, server and database roles and server permissions.
  • Participated in Disaster prevention and Recovery Strategies and supported High availability features like Snapshot Replication, Clustering (Active/Passive) and Database Mirroring.
  • Experience in Log Shipping from Primary to Standby servers and SQL maintenance plans.
  • Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server.
  • Proficient in developing business application logic using SQL Stored Procedures, Functions and
  • T-SQL queries and maintained code repository in Visual Source Safe (VSS) for deployments.
  • Created and maintained SQL objects like Tables, Constraints, User defined Functions, Indexes,
  • Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.
  • Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL
  • Server agent and monitoring and troubleshooting jobs, event notifications using Database Mail.
  • Developed Tabular Reports, Matrix Report, and Charts using SSRS and deployed to Report Server.
  • Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility

Confidential

SQL-SERVER DATABASE ADMINISTRATOR

Responsibilities:

  • Creating of Databases, Database Instances
  • Performance Tuning and Monitoring
  • Assigning users required rights and privileges to databases and sql instances
  • Generating Backup Report daily, and re-running backups before Production goes live
  • Capacity Planning and Database Growth Tracker(Monthly basis)
  • Training on New Versions and Features of Sql Server

Hire Now