We provide IT Staff Augmentation Services!

Sql Server Database Administration Resume

TX

SUMMARY:

  • 9 years of SQL Server Database Administration experience with an emphasis on design, development, enhancement, automation, tuning and optimizing databases for high Availability, Performance and Security
  • Experience in Administration & Support of MS SQL Server 2000, 2005, 2008R2, 2012 in Production, QA & Development environments.
  • Expertise in MS SQL Server Installation, Configuration, Migration and Maintenance, applying patches.
  • Expertise in SQL Server 2000, 2005 and 2008 Enterprise Edition, experience with SQL Server Enterprise Manager, SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture and SQL Profiler
  • Experience in supporting web based, mission critical applications including Logical and Physical Database Design, Development, Performance Tuning.
  • Experience in migrating older version SQL servers’ databases to SQL Server 2008 R2.
  • Possess strong skills in developing processes for Importing, Exporting and Mapping of large volumes of data and integrating with external systems
  • Experience in Supporting Production Servers 24x7, on-call basis
  • Expertise in defining Database Backup, Recovery and DR
  • Extensive knowledge and experience in developing scripts using T-SQL for querying against databases in SQL Server
  • Expertise in implementing business logic using Triggers, Views and Stored Procedures
  • Proficient at Performance Tuning with a solid knowledge of Optimizing Code and Improving Efficiency in databases including Query Tuning, Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks
  • Experience in supporting Very Large databases (VLDB), troubleshooting the problems
  • Installed, Configured and Maintained SQL Server Failover Clustering.
  • Experience in handling Database performance issues, database capacity issues, Replication, Clustering, Mirroring and other distributed data issues
  • Experience in data normalization and de-normalization.
  • Experience in data warehousing including business intelligence tools- DTS(ETL), SSIS(ETL), SSRS and SSAS
  • Experience with SQL Server Security and SQL Server Auditing and Encryption.
  • Proficient at Documentation of Database Architecture according to established standards, capacity to balance both short and long term issues effectively and handle many simultaneous and often changing priorities
  • Experience with third party tools like Red Gate, Idera and Spotlight.
  • Microsoft certified DBA with MCITP certification .
  • Very good communication skills, good interpersonal skills & desire to excel, fast learner and a versatile team player

TECHNICAL EXPERIENCE:

Relational Databases: SQL Server 2012/2008/2005/ 2000

Database Technologies/Tools: SQL Server Management Studio, SQL Server Profiler, Repository Manager, SQL Server Enterprise Manager, SQL Server Query Analyzer, Big Brother, Index Tuning Wizard, DTS Import/Export SSIS, SSRS, Silverlight, Business Objects and Crystal reports.

Operating Systems: Windows 2012, 2008, 2003, 2000, NT, 98, UNIX and Linux.

Network Protocols: TCP/IP on Windows NT 2008R2/2003/2000

Programming Languages: T-SQL, PL/SQL, C, C#, ASP.NET, VB.NET, HTML, XML.

Applications: Microsoft Office, Adobe PhotoShop.

EXPERIENCE:

Confidential

DBA

Responsibilities:

  • Maintained databases hosted on SQL server 2000/2005/2008 /2012 .
  • Installed SQL Server 2012 on Test and Production.
  • Migrated databases from SQL 2000 and SQL 2005 to SQL server 2008 R2.
  • Setup Transactional replication for reporting purpose
  • Setup Log Shipping and Database Mirroring for DR
  • Performed administrative activities like backup/restores, creating user logins with appropriate roles, granting and denying login privileges
  • Created and deployed reports (using SSRS) to the reporting server.
  • Provided on-call support once every 3 weeks.
  • Documented all the issues for future reference .

Environment: MS SQL server 2000/2005/2008 R2/2012, Windows 2000/2003/2008 R2/2012, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio and SSIS, SSRS.

Confidential
DBA

Responsibilities:

  • Maintained databases hosted on SQL server 2005/2008 R2.
  • Installed SQL Server 2012 on Dev and Test boxes.
  • Setup Transactional replication and Database Mirroring
  • Performed administrative activities like backup/restores, creating user logins with appropriate roles, granting and denying login privileges

Environment: MS SQL server 2005/2008R2, Windows 2000/2003/2008 R2, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio and SSIS, SSRS.

Confidential TX
DBA/Developer

Responsibilities:

  • Migrated databases from SQL Server 2000 to SQL Server 2008 R2.
  • Monitored databases hosted on SQL Server 2005, SQL Server 2008R2
  • Used Backup/Restore and Attach/Detach for migrating databases off of SQL server 2000 to SQL server 2008 R2.
  • Setup maintenance plans on the migrated databases.
  • Performed administrative activities like backup/restores, creating user logins with appropriate roles, granting and denying login privileges.
  • Worked on performance tuning of the queries.
  • Setup and maintained Snapshot and Transactional Replication to our Reporting servers.
  • Setup and Maintained Log Shipping
  • Administered reports through Report Manager.
  • Used SQL Jobs to schedule the package to load data in regular intervals.

Environment: MS SQL server 2000/2005/2008 /2008R2, Windows 2000/2003, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio and SSIS, SSRS, SAS, XML

Confidential IA
DBA

Responsibilities:

  • Administered SQL Servers in Dev, SIT, UAT and Prod.
  • Worked on server builds for upgrade projects and applied patches on them.
  • Worked on upgrade projects (from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008).
  • Worked on migration projects
  • Setup and maintained Snapshot and Transactional Replication to our Reporting servers.
  • Setup and Maintained Log Shipping and Clustering (Active-Passive configuration) to our BCP (Business Continuity Plan) servers (located off site).
  • Involved with SQL Server Performance Monitoring, Server and Database optimization and Query tuning.
  • Performed administrative activities like creating user logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups.
  • Worked on performance tuning of servers.
  • Created SQL traces using SQL Profiler Wizard to analyze any performance issues.
  • Used SSIS to transfer data to OLTP databases from third party vendors (text files and excel sheets).
  • Used to back up user & system databases and restored them when necessary.
  • Maintained our team’s inbox where requests (issues, tickets, model changes, physical db changes, clear case deployments etc) from the users come to.
  • 1 full week of 24 x 7 on-call support every 5 weeks.

Environment: MS SQL server 2000/2005/2008 , Windows 2000/2003, Unix, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio, SSIS, ASP.NET, C#, VB.NET, Visual Studio 2008, Win Forms, HTML, DHTML, XML, XSLT, JavaScript, IIS 6.0.

Confidential AL
DBA

Responsibilities:

  • Administered SQL Servers in development and production environments.
  • Setup and maintained transactional replication One Publisher and 4 subscriber environment for production servers. These subscribers are located in CT, England and NJ
  • Setup and Maintained Log Shipping and worked on Cluster setup on VMware.
  • Dropped and recreated the indexes on tables for performance improvements.
  • Rewritten the stored procedures on the new servers.
  • Worked on creating SQL traces using SQL Profiler Wizard and also efficiently used the PerfMon utility to capture hardware bottlenecks
  • Involved with SQL Server Performance Monitoring and Query tuning.
  • Performed administrative activities like creating user logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups
  • Used to back up user & system databases and restore them when necessary.
  • Used batch processing to load lot of data from the legacy system to SQL Server.
  • Used SSIS to transfer data from OLTP databases to staging area
  • Interacted with the Windows Server Administration team to resolve the issues.
  • Worked on 2-10 tickets per day.

Environment: MS SQL server 2000/2005, Windows 2000/2003, Unix, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio, SSIS, SSAS, ASP.NET, C#, VB.NET, Visual Studio 2008, Win Forms, HTML, DHTML, XML, XSLT, JavaScript, IIS 6.0 and SSRS.

Confidential PA
DBA

Responsibilities:

  • Upgrade experience of SQL Server 2000 to 2005. Experience in applying Service Packs at database and OS Level.
  • Migrated all the DTS packages.
  • Assisted with the implementation of Snapshot and Transactional Replication for the reporting databases.
  • Created the Maintenance Plan for optimization and integrity check for all SQL servers.
  • Used DBCC utilities, updated index statistics, monitored database and disk space; involved in security issues and scheduled tasks.
  • Used DDL and DML statements to create the objects and to manipulate the data.
  • Worked on migration and maintenance of data using various utilities like Import and Export via BCP.
  • Setup and maintained Database Mirroring.
  • Modified existing Stored Procedures.
  • Involved in query tuning processes for SQL developers
  • Worked on creating SQL traces using SQL Profiler Wizard. Performed administrative activities like creating user logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups
  • Maintained the Failover Cluster Architecture for SQL Server databases for mission critical applications.
  • Split large tables using data partitioning.
  • Responsible for maintaining 2-node clusters in SQL Server
  • Re-indexing of fragmented objects and gathering statics and tuned SQL code
  • Worked on SSIS packages to import the data from Oracle, Access and text files.
  • Involved in SQL Server 2005 Reporting Services to design various kinds of reports.

Environment: MS SQL server 2000/2005, Oracle 10g, Linux, Windows 2000/2003, SQL PLUS, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio, SSRS, Silver Light, ERStudio 7.1, C#.Net 2.0, XML, Win Forms, Windows XP, Visual Studio 2005, PERL.

Hire Now