We provide IT Staff Augmentation Services!

Sql Database Administrator Resume

Birmingham, AL


  • An experienced MS SQL Server Database Admin/Developer having more than 7(Seven) years of professional experience in Database Design, administration, ETL Processing, Report Development, Data Modeling, SQL/TSQL Scripting, Gathering and analyzing business requirement and Administering Windows Server Operating Systems. Solid working experience in managing and troubleshooting large databases, backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc. Working experience entails strong knowledge on using third party tools like Idera, SpotLite, ERWin, Visio, and Toad Data Modeler.
  • Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.


Database Expertise: SQL Server 2014, 2012, 2008 R2, 2005, 2000, MS Access

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, UNIX/Linux, VMware, Cloud

Languages: SQL, T - SQL, HTML, DHTML, XML, JavaScript, ASP, ASP.net

ETL/Data Warehouse Tools: SSIS/DTS, BCP

Reporting: SSRS (SQL Server Reporting Services) - Enterprise Reporting

Data Modeling Tools: ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)

Third Party Tools: SolarWinds, OpNet, RedGate, Idera, SpotLite, ERWin, Visio, Toad Data Modeler

Networking: Active Directory, DNS, TCP/IP

Hardware/Storage: SAN, RAID, iSCSI


Confidential, Birmingham, AL

SQL Database Administrator

Major Responsibilities:

  • Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment
  • Configured and Maintained Fail-Over Clustering using SQL Server 2012
  • Installed and Configured SQL Server Reporting Services (SSRS)
  • Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files
  • Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
  • Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/2005 to 2008 R2 and 2008 R2 to 2012
  • Migrated Oracle 10gR2/11gR2 and MySQL 5.1.23 databases to SQL Server 2008 R2/2012
  • Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
  • Performed database and SQL/TSQL Performance Tuning
  • Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types
  • Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
  • Developed Different Maintenance Plans for database monitoring
  • Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications
  • Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)
  • Worked on Data Modeling projects, Backward Engineering, Developed E-R Diagram and used multiple tools like ERWin, Toad Data Modeler, and SQL Server Data Diagram
  • Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export
  • Experience creating DDL scripts for implementing Data Modeling changes
  • Collaborated with business analysts and data analysts for Data Conversions and to resolve Gaps in business specifications and ensured that the decisions are documented
  • Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
  • Strong experience in using Excel and MS Access to dump the data and analyze based on business needs
  • Deployed SSIS packages to move data across server, move logins, load data from different data sources
  • Setup jobs from SSIS Packages
  • Used Imp/Exp Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
  • Manual, on Demand and setup jobs for Database Backup, and design backup strategy
  • Deployed and Restored database including Point in Time Recovery
  • Monitor Server Activity, Error Log, space usage and solving problem as needed
Confidential, Washington, DC

SQL Database Administrator/SQL DBA

Major Responsibilities:

  • Migrated and Upgraded from SQL Server 2005 to 2008/2008 R2
  • Configured database software, associated database tools and performance monitoring software.
  • Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
  • Performed acceptance testing to verify that database changes perform without adverse consequences.
  • Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
  • Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
  • Implemented & managed database clustering, failover and load balance technologies as per client requirement.
  • Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
  • Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
  • Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
  • Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.
  • Set up security and access profiles and procedures for database system administrators.
  • Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
  • Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
  • Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
  • Managed security by defining roles and rights.
  • Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
  • Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures.
  • Working individually, as a member of a team, and lead small teams to collaboratively design and model systems at a high level prior to construction
Confidential, Washington, DC

SQL Database Administrator/SQL DBA

Major Responsibilities:

  • Configured, Installed, and Maintained SQL Server 2000 & 2005 in development, test, and production environment
  • Installed and Configured Operating Systems, Windows Server (2000 & 2003)
  • Installed and Configured SQL Server Reporting Services (SSRS)
  • Configured and Maintained Replications, Log Shipping
  • Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment
  • Upgraded MS Access 2000/97 databases into MS SQL Server 2000, and 2005
  • Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition
  • Expertise in database Performance tuning
  • Writing T-SQL and Stored-Procedures
  • Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
  • Data Modeling, developing E-R Diagram using ERWin and SQL Server Data Diagram
  • Backward & Forward Engineering with data modeling tools mentioned above
  • Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP
  • Generated Report using SSRS and in Excel, html, text from Database as well
  • Working experience in Database Backup, Restore and Point-in-Time Recovery
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
  • Developed Different Maintenance Plans for database monitoring
  • Monitor Server Activity, Error Log, space usage, and solving problem as needed

Hire Now