We provide IT Staff Augmentation Services!

Senior Sql Server Dba Resume

4.00 Rating

Houston, TX

SUMMARY:

  • Over Nine (9+) years of IT experience wif Database Administration on MS SQL SERVER 2014/2012/2008 R 2/2005/2000/7.0 in Production, Development and Testing Environments.
  • Hands - on experience wif Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2014/2012/2008 R2/2005 on Windows 2012/2008/2003 server
  • Implemented MS SQL Server 2012 on Development and Test Environment
  • 5+ years solid experience on SQL Server Integration Services (SSIS) created solid ETL packages
  • 3+ years of experience in creating heavy duty SQL Server Reports wif (SSRS)
  • 5+ Years experience in Advanced T-SQL Programming and Application development
  • 5+ Years experience in Active/Active and Active/Passive Clustering
  • 4+ Years experience in Async and Sync Mirroring for DR and Reporting
  • 2+ Years experience wif AlwaysON Availability Groups
  • Maintained databases wif sizes ranging from Large to Very Large Databases (terabytes).
  • Strong experience wif T-SQL, Stored Procedures, Functions and Excel macros
  • Excellent Experience in Managing Security through Logins, Users, Permissions, s, Credentials, Encryption Schemes per Company’s Security Policies
  • Extensive noledge wif Backups, Restoration and Disaster Recovery Planning.
  • Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2008 R 2/2008/2005.
  • Experience in Upgrading of SQL Server from version 2005/2008 and /2012/2008 R2.
  • Highly Proficient in migration of Databases, packages and Job activities from MS SQL Server 2000 to MS SQL Server 2005/2008R2 and also migrating the database from development to production, and migrate the data between the databases.
  • 2+ Years experience in PowerShell Scripting.
  • Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's, and SQL Query Analyzer and performed Query Optimization.
  • Experience in designing & implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.
  • Experienced in Data Migration between Homogeneous & Heterogeneous Systems using various tools (SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).
  • Automated Database Consistency Checks, Fragmentation checks and Index Reorganization/Rebuilding Operations.
  • Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email & Pager notifications using SQL Server Agent.
  • Strong interpersonal and documentation skills

TECHNICAL SKILLS:

  • Windows Server 2014/2012/2008 R2
  • Windows Server 2003, MS SQL Server 2012/2008 R 2/ 2008/2005/2000
  • Enterprise Manager, Query Analyzer, Oracle 10g/11i, DTS
  • MS SQL SSRS, SSAS, SSIS, SQL Profiler, DB2,AIX,ASP.Net 2.0
  • SQL, PL/SQL, Visual Studio 2008/2005, T-SQL, ERWIN
  • Database Modeling, Microsoft VISIO, IDERA SQL Diagnostic Manager
  • SQL Litespeed, IDERA, Lumigent Log Explorer, Dell PowerEdge, HP Blade, VMware.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior SQL Server DBA

Responsibilities:

  • Provided 24/7 production support on a rotating roster schedule
  • Worked on Implementing SQL Server 2012 on Production, Dev and UAT environments.
  • Worked on Advanced level T-SQL programming, creating stored procedures, views and UDF’s
  • Implemented AlwaysoOn wif Sync and Asyn configuration.
  • Experience in working wif setting up HA groups wif the halp of Always ON.
  • Implemented AlwaysON availability groups wif three replicas for reporting and backup on SQL Server 2012
  • Upgraded and Migrated SQL Server 2005/2008 to SQL Server 2012.
  • Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
  • Designed and implemented backups/restore strategies for point in time recovery purposes
  • Worked extensively on SQL Server DMV's for Performance tuning
  • Worked on Troubleshooting and Performance tuning of SQL Server Databases
  • Used Idera SQL Safe backup tool to backup databases
  • Extensive work on debugging stored procedure and UDF for performance bottlenecks
  • Used Performance Monitor and SQL Server Profiler to optimize long running queries and improve performance
  • Worked extensively on Database space management, performance monitoring and alert management.
  • Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions
  • Involved in development of automated daily, weekly and monthly system maintenance.
  • Created Jobs and scheduled jobs according to the requirements
  • Worked wif different teams (Off shore) to deploy projects to Production, DEV and UAT environments.
  • Monitoring SQL Server Instances wif IDERA diagnostic Manager
  • Evaluating SQL Scripts of Developers and Build the Test Environments as Dupes of Prod ENV.
  • Installation of SQL server 2005,2008R2 on development and testing environments
  • Used Bug Tracker to solve the Errors.
  • Extremely effective communication and presentation skills across all levels in the organization
  • Performed Builds and Release.
  • Worked wif Powershell Scripts to Run Test Builds on Test Servers and Release on Production Servers.
  • Created Custom Jobs for certain DML and DDL Scripts

Environment: Windows 2012/2008 R2/2003/2000 Server, VMWare, Excel, SAN, MS SQL Server 2014/2012/2008 R2/2005, Business Intelligence Development Studio, DTS, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manager and other IDera tools, DTS, SSIS, SSRS,VB Script Performance Monitor, SQL Profiler.

Confidential, Plano, TX

Senior MS SQL Server DBA

Responsibilities:

  • Extensively worked in OLTP & OLAP environments that include Production, UAT and Development databases in SQL Server.
  • Provided 24/7 production support on a rotating roster schedule.
  • Worked extensively on VMware and Virtual instances of MS SQL Server
  • Worked extensively wif writing T-SQL, Stored Procedure, Functions, Views, Triggers and Excel Macros
  • Implemented SQL Server 2008R2 Active/Active cluster setup on Windows 2008 R2 servers.
  • Implemented SQL Server 2012 on Development and QA Environment
  • Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
  • Configured and Monitored MS SQL Server 2008 R2 in Log Shipping for Disaster Recovery.
  • Installed and configured SQL Server 2008R2 wif Service Packs in UAT, Development & Production environments
  • Worked wif SAN Technology and SAN boxes.
  • Created Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
  • Designed and implemented high level backups/restore strategies for point in time recovery purposes.
  • Used Idera SQL Safe backup tool to backup databases.
  • Worked wif different teams to deploy projects to UAT (Testing), Development, and Production environments.
  • Migrating SQL Server 2000/2005 7.0 databases to SQL Server 2005 and then to 2008R2.
  • Used SQL Server Upgrade Advisor to analyze SQL server 7.0 in the process of migration.
  • Converted DTS Packages to SSIS Packages using DTS Package Migration Wizard
  • Created solid ETL packages wif SSIS using various transformations, sources and destinations
  • Created packages in SSIS wif solid error handling, logging and error re-direction
  • Used VB Scripting in SSIS transformations
  • Deployed SSIS packages from one server to another and scheduled the packages for automation
  • Created heavy duty reports wif SSRS, parameterized and drill down reports
  • Configured SSRS report server
  • Created packages successfully using SSIS to transfer large volume of Data.
  • Monitoring SQL Server Instances wif IDERA diagnostic Manager

Environment: Windows 2008 R2/2003/2000 Server, VMWare, Excel, SAN, MS SQL Server 2008 R2/2005/2000,, Business Intelligence Development Studio, DTS, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manager and other IDera tools, DTS, SSIS, SSRS,VB Script Performance Monitor, SQL Profiler.

Confidential, Philadelphia, PA

Senior MS SQL Server DBA

Responsibilities:

  • Installed Standalone and Clustered SQL Server 2005/2008 R2 instances in Production, Development, Test, Staging environments.
  • Experience in setting up High Availability environments like Active-Active and Active-Passive Clustering.
  • Managed Oracle Servers in Production environment, managed Backups, Installations and security in Oracle
  • Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
  • Worked extensively on Database space management, performance monitoring and alert management.
  • Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.
  • Administered the MS SQL Server by creating user logins wif appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
  • Suggested backup strategies, Scheduled backups and Performed restoration operations.
  • Worked wif migrating data from SQL Server 2000 and 2005 to SQL Server 2008.
  • Created Jobs and scheduled jobs according to the requirements.
  • Created linked server between SQL servers.
  • Designed and created ETL process and design in SSIS
  • Implemented various transformations and created SSIS packages
  • Created SSRS simple and Drill-down reports depending on client requirement
  • Dropped and recreated the indexes on tables for performance improvements.
  • Written complex stored procedures and functions and integrated it wif the front end application.
  • Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
  • Data transfers between various servers using BCP and DTS.
  • Extensively used SSIS to move data from text files to SQL Server.
  • Created packages successfully using SSIS to transfer large volume of Data.

Environment: Windows 2008/2003 Server, MS SQL Server 2008/2005/2000, Business Intelligence Development Studio, T-SQL, SSMA, Lite Speed, DTS, SSIS, SSRS, BCP, SQL Profiler.

Confidential, Camp Hill, PA

Senior MS SQL Server DBA

Responsibilities:

  • Provided 24/7 on call production support.
  • Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.
  • Worked on installing, configuring and maintaining of SQL Server 2000 and 2005 on Windows server 2003.
  • Configured the Log shipping and scheduled jobs to setup log shipping between production servers.
  • Implemented and tested the point in time recovery of the production databases.
  • Implemented Transactional Replication between Primary Server and Sub Systems.
  • Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
  • Created Users and Roles, and managed security and permission of different SQL Server objects.
  • Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.
  • Running DBCC consistency check, and fixing data corruption in user databases.
  • Experience in Tuning Databases using Performance Dashboard.
  • Developed several reports using SQL server Reporting services (SSRS).
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Maintained stand by servers using log shipping and replication concepts.
  • Prepared the coding guideline documents for SQL server developers.
  • Extensively used SSIS to move data from text files to SQL Server.
  • Coordinating wif the development team regarding tuning the SQL queries and stored procedures.

Environment: Windows Server 2003, Microsoft SQL Server 2008/2005/2000, T-SQL, Business Intelligence Development Studio, Database engine tuning Advisor, SSIS, SSRS, BCP, SQL Profiler.

Confidential, Cincinnati, OH

SQL Server DBA

Responsibilities:

  • Involved in development activities including hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.
  • Responsible for configuration, Tuning of MS SQL Server 2005 and provided 24 X 7 dedicated support to all production and development servers.
  • Involved wif Installation, Upgrade Troubleshooting of MS SQL Server 2000 to MS SQL Server 2005 Databases and Servers.
  • Responsible for migration of databases from one version to other versions and applying patches.
  • Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures
  • Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
  • Actively involved in Normalization (3NF) & De-normalization of database.
  • Scheduled Jobs and Alerts using SQL Server Agent.
  • Configured Transactional replication between Primary Server and three Read - Only servers, wif separate Distributor server and experience in replication problems.
  • Used DDM (Data Dependency Mechanism) to balance the load of data across multiple servers.
  • Involved in capacity planning in estimating troubleshooting and sizing of tables.
  • Developed complex Stored Procedures.
  • Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment: Windows Server 2003, SQL Server 2005/2000, SQL Server Analysis Services, VB, SAN, DTS, SSIS

We'd love your feedback!