We provide IT Staff Augmentation Services!

Sr. Sql Server Database Administrator (dba) Resume

Kansas City, MO

SUMMARY

  • 10+ years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2017/2016/2014/2012/2008 R2/2008 in Production, Test, Development and Cluster Server Environments.
  • 2+ Years of experience in Data Warehousing and Business Intelligence using SSIS, SSRS and SSAS along with Scripting using PowerShell.
  • Experience in OLTP and OLAP environment that includes Production, QA and development databases in SQL Server. Delivered scalable database deployments, managed multiple production databases, automation.
  • Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
  • Very good experience in Installation, configuration, and maintenance of SQL Server.
  • Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
  • Experience in scheduling Backups, Restores and Maintenance plans using Native tools.
  • Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
  • Very good in T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Proficient in Replication-Snapshot, Database backup and Disaster Recovery (DR) procedures.
  • Very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem-solving skills.

TECHNICAL SKILLS

Web technologies: HTML, CSS, JavaScript, ASP.NET

Programming Languages: C, C++, and T-SQL

RDBMS: Microsoft SQL Server (MS-SQL), Microsoft Access

Database Tools: Management Studio, SQL Server Data tools Microsoft, Visual Studio 2013, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Export and Import

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Sr. SQL Server Database Administrator (DBA)

Responsibilities:

  • Administrated and Managed SQL Server 2016/2014/ 2008 R2 databases in Production, integration and testing stages.
  • Providing Production and Application Support for the Database and Application Servers.
  • Performing routine DBA tasks like monitoring SQL Server health, scheduling jobs, creating maintenance plans. Checking servers for optimizations and implementing them.
  • Created Linked servers accordingly in between the different servers based on the requirement.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
  • Implemented Pager options to inform corresponding DBA basis on Each Job Status.
  • Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
  • Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
  • Performed Backup and recovery & Automation of Backups using maintenance plans.
  • Monitoring database growth and performing remedial actions as necessary.
  • Implemented MDW, monitoring MDW reports and its performance.
  • Implemented PBM, monitoring its activity on non-production servers.
  • Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
  • Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
  • Worked in Active/Active Cluster environment as a High availability solution.
  • Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
  • Involved in Installation process and Configuration of MS SQL Server 2014 in year 2016. Participated in Disaster Recovery exercise in year .
  • Successfully Migrated data from MS SQL Server 2008R2 to MS SQL Server 2014 environment.
  • Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
  • Constructed SSIS packages, tested and implemented to import-export OLEDB sources.
  • Deploying and Troubleshooting SSIS packages with a multitude of Data sources and complex data conversion logics.
  • Performing Refresh of databases in CERT/ DEV-INTG environment with respect to Production data for every 90days. This includes Data Base Backup and Restoring, Killing/Setting up connections, Replication, monitoring all jobs are running as usual.
  • Daily tasks include- verifying production servers morning status report; monitoring/verifying non-production and production alerts for job failures to give database access(read/write/exec/update) to users that are in queue in the system; delete access for users in the queue; documenting any important steps/resolutions and uploading it to share point folder.
  • Thorough understanding of Windows OS as well as PowerShell scripting and Active Directory integrations with SQL Server.
  • Developed PowerShell scripts and automation to support our enterprise automation strategies and goals.
  • Wrote T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD
  • Proposed and Implemented DR Strategy for Critical Databases using Database Mirroring, Log Shipping and using Always ON Availability Group based on Recovery Time Objective (RTO).

Environment: MS SQL Server 2017, 2016, 2014, 2008R2, Windows 10, Windows 7 Enterprise version 6.1, MS SQL Server Integrated Services (SSIS), Reporting Services (SSRS), SQL Profiler, Share point services, PowerShell, App Dynamics monitoring tool.

Confidential, Dearborn, MI

SQL Server DBA

Responsibilities:

  • Administrated and Managed SQL Server 2012/2008R2/2008 databases in Production, Staging, QA and development environments.
  • Responsibilities include the Production and Application Support for the Database and Application Servers.
  • Served as a technical advisor on database growth and storage issues. Forecasting future growth of the database and remedial measures to contain the pace of the growth.
  • Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
  • Installing, Configuring and Maintaining SQL Server 2012/2008R bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
  • Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
  • Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
  • Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: MS SQL Server 2012/2008R2/2008, Windows 2008 server, MS SQL Server Integrated Services (SSIS), Visual Studio, SSRS Reporting Services, .NET Framework.

Confidential

SQL Server DBA

Responsibilities:

  • Involved in Installation and Configuration of MS SQL Server 2008.
  • Migrated data from MS SQL Server 2005 database to MS SQL Server 2008 database.
  • Used Microsoft SQL Profiler to analyze the queries and improve their performance.
  • Analyzed Business Requirements and segregated them into high- and low-level Use Cases and Activity Diagrams using MS Visio.
  • Worked closely with the architects and technical team during Data Mapping and Data Integration.
  • Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
  • Expert in Configuring, Managing and optimizing transactional replication.
  • Implemented built in log shipping with SQL Server 2000 for disaster recovery server.
  • Conducted iterations and communicated results and milestone achievements to the stakeholders while keeping the developers closely updated on all documented refinements.
  • Associated with the Performance Testers and was involved in fixing of Performance related issues.

Environment: MS SQL Server 2005/2008/2008 R2 Enterprise edition with clustering, Windows 2003, 2008 server NT, IIS Server 6.0, SSIS, SSRS.

Confidential

Associate DBA

Responsibilities:

  • Review / test / apply all database changes to all environments including QA, Development and Production Servers.
  • Monitor SQL Error Logs, Schedule Tasks, database activity, eliminate Blocking & deadlocks, user counts and connections/locks etc.
  • Worked with SQL server Profiler to generate traces.
  • Monitored the database and alerts from Fog light application and also performance monitor for the performance.
  • Experience in taking the backups and schedule it according to the environment, Recovery.
  • Develop some DTS packages to Message the data and put into other tables, which are used for reporting.
  • Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
  • Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.
  • Creating the Packages for running the jobs automatically for backup and data transfer.
  • Good in Implementing SQL Server security and process control
  • Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.
  • Implemented and documented proactive monitoring scripts for production databases.
  • Preparing the reports for the day-to-day as well as weekly/monthly purposes.
  • Conducting root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.

Environment: SQL Server 2005/2008, Visual studio.net, Windows XP/2000 and Windows 2003 server, HP net server LP1000r server.

Hire Now