We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Dallas, TX

Professional summary

  • 7 + years of experience in MS SQL SERVER 2008R22008,2005/2000/7.0 Database Development and Administration (DBA) in business & technical environments like Banking, and communication industries with a strong working knowledge of DTSBusiness over Intelligence and Reporting services.
  • I have an experience in database administration activities like installationconfiguration, and backup & recoverydatabase lifecycle: 5+ years, installation: 5+ years, configuration: 5+ years,data migration and upgradation: 5+ years, strong sql server: 6 years, hands on legacy environment exp, large scale automation exp: 800 million rows and columns
  • Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
  • Implemented and successfully tested Database Mirroring in SQL Server 2005.
  • Expert in MS SQL Server suite of products like SSRS and SSIS of MS SQL Server 2005.
  • Experience inMicrosoft Analysis Services
  • Experience in working with different environment like oracle, my sql.
  • Experienced in sorting the data, defining data source and subtotals for the reports.
  • Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Experience with standard Microsoft tools.
  • Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
  • Developed cubes SSAS and extracted data using MDX queries.
  • Experience in Designdeployment, and maintenance of various SSRS Reports in SQL Server 2005.
  • Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Experienced in the installation and configuration of SQL Server 2000/2005/2008.
  • Experience in Creating Roles and Assigning Permissions to the users.
  • Implemented different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server 2000 and SQL Server 2005 in OLTP Environments.
  • Experience In Database Backup, Recovery and Disaster Recovery Procedures.
  • Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
  • Extensive knowledge in Tuning SQL queries & improving the performance of the Database by creating and updating clustered and non-clustered indexes.
  • Hands on experience in Log shipping with SQL Server 2000/2005.
  • Experience in Analyzing Execution Plan, Managing indexes and troubleshooting deadlocks.
  • Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle, Sybase and DB2.
  • Experience in using SQL ServerProfilers, Index Tuning Wizard and Windows Performance monitor to monitor SQL Server.
  • Hands on experience in MS access
  • Experience in Partitioning tables to achieve better performance for access and writes.
  • Experience inMicrosoft Integration Services
  • Excellent analytical, interpersonal and communication skills and desire to excel, fast learner, Hardworking and versatile team player
  • Capable of learning new technologies and processes, and successfully applying them to projects and operations
  • Highly dedicateddynamic, ability to meet deadlines within fast paced environments
  • Self-StarterResult OrientedResponsible Team Member and Co-Operative Individual

Technical Skills

Languages

C, C++, T-SQL, .NET

RDBMS

MS SQL Server 6.5/7.0/2000/2005/2008, MS-Access,My sql and Oracle 8i/9i/10g

Web Technologies

Asp.Net with C# (Framework 1.1/2/0/3.5), HTML, XML and Java Script

Reporting Tools

Crystal Reports, SQL Server Reporting services (2000/2005)

Web Server Technologies

IIS 5.1/6.0

Database Tools 

SQL Server Management Studio, SQL Server Enterprise Manager, Query Analyzer, Crystal Report, SQL Server Reporting Service, SQL Server Analysis Services.

Development skills 

T-SQL, PL/SQL 

Operating Systems 

Windows 9x/2000/NT/XP, Windows Server 2003,UNIX ETL Tools DTS (Data transformation services), Integration Services (SSIS),

Software Packages 

Office 2000/2002/XP/2003/2007: MS Word, MS Excel, PowerPoint, MS Access, Visio

Education 
B Tech in computer science from Confidential

Professional experience

Client : Confidential, TN Nov 11 – Present 
Title : SQL Server DBA
Confidential Corporation provides services and insurance products to wireless carriers and subscribers in North America, the Asia Pacific, and Europe. The company also provides Mobile Recovery, a Web- and phone-based application that helps customers in the event of phone loss or misplacement

Responsibilities

  • My major work was to design and rebuild the infrastructure of environment.
  • That includes creating new SQL Servers boxes and upgrading 2000 SQL Server to 2008 and 2005 to 2008.
  • Had opportunity to create and work SQL Server 2012
  • Worked on patching the SQL Server with latest patch level
  • Creating mount point and resolving space issues on the server.
  • Implemented database standards and naming convention for the database objects
  • Manages and maintains all production and non-production databases.
  • Worked on creating Logshipping and Replication
  • Worked on resolving the logshipping latency issues
  • Design of physical data storage, maintenance, access and security administration and correct functioning of backup and recovery on DBMSs.
  • Worked on performance of Table spacedata file space errors, blocking locks, application errors Client software issues and Poor performance.
  • Worked both, Veritas and Microsoft cluster failovers.
  • Worked on resolving the disk space issues.
  • Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Development activitiesAdvisor for index recommendations.
  • Used System procedures and DBCC commands.
  • Active Directory Administration, user logon scripts.
  • Wrote complex T-SQL queries using joins according to the requirement.
  • Implemented various levels of constraints and triggers to preserve long term database consistency and accuracy.
  • Created standard documents for ever procedure as part of standardizing them.
  • Wrote different scripts to pull user login ,logins with SQL server admin access and list of DB owners for better auditing purposes
  • Design and implementation of standards across all the SQL Servers.
  • Worked creating a SQL Server QA check list which is used to standardize the whole environment Created
  • Created a mechanism to check if all the standards are present across environment
  • Evaluated, examined and implemented user roles and assigned relativedatabaseaccess privileges.
  • Disaster recovery planning, security management, implementation of sql logins, roles and authentication modes as a part of security policies for various categories of users.
  • Experienced in performance of the server using DMV commands.
  • Worked on creating standard operation procedures (SOP)
  • Worked creating a new SLA’s
  • Worked creating a SQL Server QA check list which is used to standardize the whole environment
  • Created

Environment: Windows 2003/2008 server, MS SQL Server 2000/2005/2008 R2, MS Access, T-SQL, MS Excel, veritas cluster,litespeed.

Confidential, Dallas, TX Jun 2010 – Oct 2011 
SQL DBA

Confidential mainly gives backend software support for many companies including Verizon, Bank of America And so on…My major role in this company is to maintain the server of OneSource application and gold - mine application which are the major applications of the Verizon and Bank of America. I worked in the  Conversion project where I had chance to work on transferring the data from one server to another  Secured server

Responsibilities:

  • Installation and Maintenance of SQL Server 2008 on Test, Development and Production Environments.
  • Worked with SQL Server 2005/08 side by side upgrade from SQL server 2000.
  • Creating SQL LoginsRoles and Authentication Modes as a part of Security Policies.
  • Implemented Disaster Recovery PlanningTesting and Analyzing, continuous update of documentation.
  • Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD and dedicated admin connection.
  • Successfully implemented the Capacity planning for different servers.
  • Creating and Maintaining Database Maintenance Plans.
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
  • Tune slow running queries using SQL Server Profiler.
  • Performed data partitioning for efficient management of database tables and indexes.
  • Maintaining the database consistency with DBCC at regular intervals
  • Monitoring SQL server performance using profiler to find performance and deadlocks.
  • Managed Disk spacememory and User connections.
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers.
  • Generated Script files of the databases whenever changes are made to stored procedures or views.
  • Rebuilding the indexes at regular intervals for better performance.
  • Worked in Active passive cluster environment.
  • Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 1.2 TB for OLAP databases.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Experience in applying Service Packs at database and OS Level.
  • Technical Analysis, Code Review, Implementation, 24 x 7 production support.
  • Checking Database Health by using DBCC Commands and DMVS
  • Did Performance Tuning of the Stored Procedures.
  • Hands on experience in trouble shooting database issues

Environment: - SSMS SQL Server 2008/2005/T-SQL, Windows XP, Windows 2000, 2003, 2008 Advanced servers.

Confidential, Houston, TX Aug 08 – Dec 09
SQL DBA
Confidential is the leading provider of high-end digital printing solutions. Fully integrated, their vast digital footprint enables customers to print close to their distribution points. Consolidated Graphics has the largest and most technologically advanced sheet fed printing capabilities. They developed a product called DPCS which helps the printing companies to work effectively. My responsibility over here is to develop, implement, trouble shoot and monitor all the production instances.
Responsibilities:

  • Installation and Maintenance of SQL Server 2008 on Test, Development and Production Environments.
  • Worked with SQL Server 2005/08 side by side upgrade from SQL server 2000.
  • Creating SQL LoginsRoles and Authentication Modes as a part of Security Policies.
  • Implemented Disaster Recovery PlanningTesting and Analyzing, continuous update of documentation.
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
  • Expertise in SQL server Reporting Services(SSRS)
  • Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD and dedicated admin connection.
  • Successfully implemented the Capacity planning for different servers.
  • Creating and Maintaining Database Maintenance Plans.
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
  • Tune slow running queries using SQL Server Profiler.
  • Performed data partitioning for efficient management of database tables and indexes.
  • Maintaining the database consistency with DBCC at regular intervals
  • Monitoring SQL server performance using profiler to find performance and deadlocks.
  • Managed Disk spacememory and User connections.
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers.
  • Generated Script files of the databases whenever changes are made to stored procedures or views.
  • Rebuilding the indexes at regular intervals for better performance.
  • Worked in Active passive cluster environment
  • Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 1.2 TB for OLAP databases.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Experience in applying Service Packs at database and OS Level.
  • Worked on maintenance MS access databases.
  • Technical Analysis, Code Review, Implementation, 24 x 7 production support.
  • Experience in using ERWIN tool for Entity Relationship diagrams.
  • Checking Database Health by using DBCC Commands and DMVS
  • Did Performance Tuning of the Stored Procedures.
  • Hands on experience in trouble shooting database issues.

Environment: SQL Server 2008/05/00, Windows 2003, Windows 2000 Server, MS SQL Server 2000/2005, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008.

Confidential, San Antonio, TX Dec 2007 – July 2008
MS SQL DBA
Confidential, a Fortune 100 company, is an independent refiner and marketer of petroleum products. Tesoro, through its subsidiaries, operates seven refineries in the western United States and Tesoro\'s retail-marketing system includes over 870 branded retail stations, of which over 380 are company operated under the Tesoro®, Shell, Mirastar, and USA Gasoline™ brands.
Responsibilities:

  • Installed and configured different editions of SQL Server 2005 like Express edition, Enterprise edition with the latest service pack.
  • Successfully migrated from SQL Server 2000 to SQL Server 2005 on Development and Testing Environment.
  • Converted all existing DTS package of MS SQL 2000 to SSIS packages by using package migration wizard and deployed new Package in different Server.
  • Build and maintain SQL scripts, indexed and complex queries for data analysis and extraction.
  • Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, databaseintegrity verification, indexing and statistics updates.
  • Implemented log shipping, database mirroring and transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
  • Monitoring & Analysis of SQL Log, Perfmon counters and Performance Tuning for all development and staging environment.
  • Provided 24 X 7 dedicated supports for SQL Server production server

Environment: MS SQL Server 2005, MS SQL Server 2000, SSMS, DTS, SQL Server Integration Services, SQL Server Reporting Services, Crystal report 9.0,IIS server 6.0

Confidential Aug 05 – Nov 07 SQL Developer

Confidential is a software products and services company that focuses primarily on Business Process Management & Banking solutions. It provides custom software development to the clients.
Responsibilities:

  • Writing DTS Package to import Data from Excel sheet and Text Files to Database Tables.
  • Installation of SQL Server 2000.
  • Designed Logical and Physical database design using Diagram feature in SQL Server
  • Writing Stored Procedure and Triggers.
  • Creating Databases and Users.
  • Worked on MS Access
  • Configuration of SQL Server Jobs for Full, Differential and Transaction Log Backup.
  • Restoring the Database to Disaster Recovery Server.
  • Performing Point in Time Recovery.

Environment: MS SQL Server 2000, Windows 2000, Windows 2000 Professional, Microsoft VBScript/JScript, T-SQL,MS Access

Hire Now