We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

Atlanta, GA

SUMMARY

  • Results oriented DBA professional with 15 plus years of professional experience in database design and systems development.
  • Strong experience in in SQL Server configuration and installation.
  • Expertise in managing, monitoring and troubleshooting SQL Servers 2000, 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017.
  • Expertise in SQL query optimization and constructing triggers, user defined functions, views, indexes.
  • Expertise in relational database modeling and design, data dictionaries, and data integrity.
  • Expertise in ETL (Extract, Transform, Load) using the Microsoft DTS/SQL Server Integration Services (SSIS).
  • Expertise in deployment of SSRS - SQL Server Reporting Services.
  • Expertise in PCI DSS compliance, data tokenization and encryption.
  • Experience in automation through SQL stored procedures.
  • Deep understanding of Microsoft cloud concepts (Azure).
  • Database Upgrade for all versions of SQL Server from SQL 2000 to SQL 2017.
  • Experience working in very large database (VLDB) environment with database size in terabytes.
  • Solid experience in SSAS - SQL Server Analysis Services.
  • Solid experience and outstanding noledge of high availability and disaster recovery (HADR) SQL Server solutions, including Always-On Availability groups, Log shipping, Replication, Database Mirroring and SQL Server clustering.
  • Experience of Data Migration from Development to QA to Production.
  • Backup monitoring and disk space monitoring on Storage Area Network (SAN).
  • Excellent communication, presentation and interpersonal skills.
  • Strong troubleshooting and organizational skills, SR management with Microsoft Support.
  • Create and update SQL server build standards, security standards, apply patches and user guides for SQL Servers.
  • Extensive experience in Clustered (WSFC) and Non-Clustered environment.
  • Experience as 24/7/365 on-call production support DBA.
  • Experience working in multi-database environment with Oracle DBAs.

TECHNICAL SKILLS

Technologies: VC#, VB, Java, Web Services, Agile Methodology, JIRA, COM/DCOM, ActiveX controls, ASP, ASP.NET, VB Script.

Operating System: Windows Server 2012, 2008 R2, 2003, 2000

Database: MS SQL Server 2017, 2016, 2014, 2012, 2008R2, 2008, 2005, 2000, 7; Oracle 11g, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft Azure.

Development Tools: SQL Server Management Studio (SSMS), Visual Studio 2015, 2013, 2012, 2010, 2008, SSIS 2014, 2012, Business Intelligent Development Studio, Report Builder, SQL Server Data Tools (SSDT), Microsoft Silverlight, TOAD for Oracle, PowerShell.

Versioning System: TFS, VSS, Subversion, CVS, Git.

Other: SQL Diagnostic Manager by Idera, SQL Profiler, Database Tuning Advisor, MS Project, MS Office, Argent Job Scheduler, Foglight, Redgate, Voltage tokenization.

Data Modeling Tools: ER Studio.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. SQL Server DBA

Responsibilities:

  • Database logical design and physical design.
  • Creation of constraints and functions and stored procedures.
  • Created application interface in Silverlight to enter and update configuration items.
  • Manage permissions for different users to database as well as interface.
  • Database replication between Prod and DR for CMDB database.
  • Automated data archive for log tables based on configuration.
  • Creation of SQL jobs for alerting appropriate groups for failed or missing activities.
  • Created PowerShell scripts to monitor database and other processes based on configuration items in CMDB.
  • Compression of data in tables with different levels of compressions (page/row/no) based on the requirement.
  • Annual encryption key rotation for databases encrypted with Transparent Data Encryption (TDE).
  • Migrating on-premise databases to Azure.
  • Created process log which runs every 30 seconds on every SQL Server and captures a snapshot of processes and logs into a table which can be used to diagnose issues.
  • PowerShell script to capture all server information from Active Directory (AD) and discover SQL Servers in the network and record and update information in a table.
  • PowerShell script to check if any system login is locked out or not.
  • Created a SharePoint report which auto refreshes and displays any failed or out of order component.
  • Created SQL jobs to capture disk free space on every SQL Server every night and based on that predict future disk space issues and alert appropriate users.
  • Capture and record SQL Server clustering information like active node using PowerShell.
  • Created SQL Server Agent start up jobs which gives SQL Server start up information like start time, active node, passive nodes, SQL Server version and any job got cancelled due to SQL Server shutdown/restart.
  • Created SQL stored procedure which calls a SQL job and waits for its completion which is mainly used to call SSIS package from Argent job schedular.
  • Automated User Access Management for production database access to users which manages user access levels and duration based on requirement.
  • Daily database restores from production to Business Intelligent (BI) servers.
  • In-house development of data warehouse which gathers data from different production sources to BI environment.
  • Data tokenization and detokenization using voltage to move data between restricted network zone and not restricted network zone.
  • Data replication from SQL view to table to replicated protected data to not restricted network zone.
  • Database upgrade from SQL 2008 to SQL 2012 and SQL 2014.
  • Implementation of Distributed Always-On availability group on SQL 2017.
  • Data center migration for Stand-alone SQL Servers and clustered SQL Servers.
  • Deployment of SQL Server Reporting Services (SSRS) reports to SharePoint using Visual Studio 2015.
  • Documentation of Standard Operating Procedures (SOP) and noledge transfer (KT) sessions with team members.

Confidential, Atlanta, GA

Sr. SQL Server DBA

Responsibilities:

  • Logical and physical design of database and objects.
  • Creation of partition functions, partition schemes, tables, indexes, stored procedures.
  • Automate partitioning by scheduling t-sql script in SQL Agent jobs.
  • Automate data deletion for older dates and database file deletion.
  • Automate creation of daily partitions and monthly files in database.
  • Implemented automated sliding window-based partition management for large tables.
  • Creation of staging tables with same structure as production tables and same indexes and switch partition is used to switch data from staging to production tables which is very fast.
  • Creation of SSIS packages and SQL jobs to run Argent schedular jobs to copy data from very large text files (10 GB - 7 million rows) to SQL tables.
  • On-call production support for mission critical databases.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

  • Installed clustered SQL Server instances in windows clusters.
  • Worked with Microsoft support for cluster installation related issues.
  • Implemented database mirroring between data centers.
  • Configured Peer to Peer (P2P) replication between two databases and during data center migration added one more node (3 node P2P) just for migration to avoid downtime.
  • Worked with developers to halp them with mirrored database connection string.
  • Created stored procedures to handle different identity ranges for different data centers.
  • Created scripts to generate different identity ranges and update existing tables without table drop/recreate.
  • Configured Merge replication for a database.
  • Applying patches in round robin fashion on cluster nodes and switching mirrored databases.

Confidential, Atlanta, GA

SQL Server DBA/Developer

Responsibilities:

  • Create DBA STATS database on each server.
  • Create stored procedures to run backup with parameters for type of backup, storage location, encryption, compression etc.
  • Automated managing backup files on data domain.
  • PCI, DSS compliance and data tokenization and data encryption including encryption key management
  • Database deployment from development to QA to Stage to Production.
  • Develop scripts for routine tasks and automation.
  • Manage database encryption.

Confidential, Chicago, IL

SQL DBA

Responsibilities:

  • Setting up new SQL Servers 2005, SQL Server 2008 and configuring the required users.
  • Database design and data modeling using ER Studio.
  • Regular monitoring of servers, dis includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
  • Installing SQL Server service packs based on the errors and flaws that are found in the application.
  • Managing Replication, Database Mirroring, Log shipping and SQL Server clusters.
  • Data Upgrade from SQL 2000 to SQL 2005 and to SQL 2008.
  • Creating and deploying reports using Reporting Services.
  • Managing SQL Server nodes on Cluster.
  • Working with SQL Server 2008 in Development environment.
  • Managing backups using Red-gate.
  • 24/7 On-call support and production support.

Confidential, Atlanta, GA

SQL DBA

Responsibilities:

  • Setting up new SQL Servers 2005 and configuring the required users.
  • Database design and data modeling using ER Studio.
  • Restoring and copying Production Databases.
  • Regular monitoring of servers, dis includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
  • Installing SQL Server service packs based on the errors and flaws that are found in the application.
  • Managing Replication, Database Mirroring, Log shipping and SQL Server clusters.
  • Managing SSIS packages/DTS packages.
  • Managing backups using Redgate.
  • 24/7 On-call support and production support.

Confidential, Beaverton, OR

SQL DBA

Responsibilities:

  • Setting up new SQL Servers 2005 and configuring the required users.
  • Database design and data modeling using ER Studio.
  • Restoring and copying Production Databases.
  • Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
  • Installing SQL Server service packs based on the errors and flaws that are found in the application.
  • Managing and troubleshooting Replication, Database Mirroring, Log shipping and SQL Server clusters
  • Resolving various performance issues and running DBCC commands, SQL Profiler and NT monitoring tools.
  • Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. SQL Autantication
  • Managing databases, tables, indexes, views, stored procedures, enforcing business rules with triggers and user defined functions.

Confidential, New York, NY

SQL DBA

Responsibilities:

  • Setting up new SQL Servers 2000 and 2005 and configuring the required users.
  • Restoring and copying Production Databases.
  • Maintain and troubleshoot Replication issues by continuous monitoring of replication.
  • Regular monitoring of servers, dis includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
  • Installing SQL Server service packs based on the errors and flaws that are found in the application.
  • SQL Server Administration, service start, pause, stop, failover.
  • Resolving various performance issues and running DBCC commands, SQL Profiler.

Confidential, Minneapolis, MN

SQL DBA

Responsibilities:

  • Documented Disaster Recovery Plans and participated in disaster recovery.
  • Running Index tuning wizard, implementing Log Shipping.
  • Monitoring SQL server, Application logs and analyzing the logs.
  • Maintaining both Development and Production servers in sync.
  • Creating users and assigning permissions. Windows and SQL Autantication.
  • Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.
  • Data conversion, database upgrade from SQL 2000 to SQL 2005
  • Writing the Stored Procedures, checking the code for efficiency.
  • Maintenance and Correction of Transact Sequel Server (T-SQL) Statements.
  • Working with various departments while developing their applications, assisting in Database design, phasing from development to QA and to Production environment.
  • Rebuilding indexes on various tables.
  • Involved in Installing, configuring and maintenance of SQL Server 2005.
  • Working with Oracle DBAs for application support.

Confidential

SQL Developer

Responsibilities:

  • Database Design, schema, tables, rules, constraints, defaults.
  • Write and tune Stored Procedures, Triggers and schedules for SQL Jobs, Stored Procedures, Jobs & Alerts, Stored procedures & Alerts notification via SQL mail.
  • Effectively handling the Data Transformation Services. Index Tuning.

Hire Now