We provide IT Staff Augmentation Services!

Sql Database Administrator Resume Profile

General, OH

PROFESSIONAL SUMMARY:

  • Six plus 6 Years of experience in Database Administration for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • SQL Server 2012, SQL Server 2008R2, and experience in database clustering, mirroring and replication and good knowledge of SQL Server 2012R2 Always-on High-availability.
  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
  • Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS configurations.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Extensively worked on SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
  • Experience in supporting Very Large databases VLDB and troubleshooting the problems.
  • Worked on configuring SQL Server with minimum privileged access.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Experience in Installing, deploying, configuring, monitoring web applications on IIS servers that runs on Windows server 2000, 2003,2008
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
  • Experience in Configuring Websites on IIS 5.0 / 6.0/7.0 for high availability on various windows environments.
  • Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
  • Experience in Disaster Recovery Planning and Security Management operations.
  • Experience in installing, configuring SQL Server 2005/2008 in large scale environments
  • Experience in migrating applications between windows servers and to an upgraded platform from IIS 5 to IIS 6 and including IIS 6 to IIS 7
  • Having hands on experience in DR processes including LogShipping and Database Mirroring.
  • Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
  • Having Experience on Data center servers and handling 1.4 TB databases.
  • Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008
  • Troubleshoot performance problems, fine-tuning of databases and index Analysis.
  • Working knowledge of various digital media formats.
  • Expert in Security Administration creating Users, Roles, Granting Privileges, Managing Schemas 2005 handling Database Security for windows/web applications.
  • Strong experience in mentoring team members and writing documentation.
  • 24 X 7 Production Database on Call Support

Technical Expertise:

  • Databases: MS SQL Server 2012, 2008 R2,2008 MS SQL Server 2005
  • Programming: Visual Basic 6, Visual Basic 5, C, C T-SQL, PowerShell2.0, 3.0
  • DBA: Database administration of MS SQL Server 2012, 2008R2, 2008 2005
  • Operating System: Windows 2008 R2/2008/2003 Advanced Server, NT Windows 9x, Linux
  • Other Software: Windows 2008 R2/2008/2003 Advanced Server, NT Windows 9x, Linux
  • Tools: Backup Utility, SQL Lite Speed, Visio
  • Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SMTP

Professional Experience Details:

Confidential

SQL DATABASE ADMINISTRATOR

Responsibilities

  • Migrated SQL server 2008 R2 to SQL Server 2012 in Microsoft Windows Server 2008 R2 Enterprise Edition.
  • Migrated SSIS packages from SQL Server 2005 to SSIS 2008.
  • Extensively worked on SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
  • Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Automated messaging services on server failures, for task completion and success.
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • SQL 2000,2005 Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
  • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor DTA .
  • Experience in using PowerShell 3.0 script we scheduled the jobs,Session connectivity kind of stuff.
  • Experience in Installing, deploying, configuring, monitoring web applications on IIS servers that runs on Windows server 2000, 2003,2008
  • Experience in Configuring Websites on IIS 5.0 / 6.0/7.0 for high availability on various windows environments.
  • Experience in installing, configuring SQL Server 2005/2008 in large scale environments
  • Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.
  • Experience in migrating applications between windows servers and to an upgraded platform from IIS 5 to IIS 6 and including IIS 6 to IIS 7
  • Rebuilding / monitoring the indexes at regular intervals for better performance.
  • Expert in implementing the snapshot isolation and DDL triggers.

Environment: SQL Server 2008/2008 R2/2012Enterprise, Windows Enterprise Server 2008 R2 ,IIS 7.5, .NET, Microsoft Visio 2003, SFTP, Microsoft Reporting Services.

Confidential

SQL DATABASE ADMINISTRATOR

Responsibilities

  • Performed daily tasks including backup and restore by using SQL Server 2008 R2/2008tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
  • Extensively worked on Dynamic Management Views in SQL Server 2005.
  • Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
  • Prepared DFDs Entity Relationship ER diagrams.
  • Transferring the data ETL to Data warehouse Informatica by SSIS.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Perform business analysis, technical analysis, systems design, application software programming.
  • Prepared the project management and technical documentation.
  • Unit Testing the SSIS packages with respect to its flow and performance issues.
  • Solving the Bugs Reflected by the Testing team.
  • Rebuilding the indexes at regular intervals for better performance.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Extensively worked on DBCC commands and Dynamic Management Objects.
  • Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Complete documentation about the database. Recovering the databases from backup in disasters.
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings for better server management.
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2008R2/2008 Enterprise, Windows Enterprise Server 2008,IIS 6.0, IIS7.5,.NET, Microsoft Visio 2003, SFTP, Microsoft Reporting Service and ASP.

Confidential

SQL DATABASE ADMINISTRATOR

Responsibilities

  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Rebuilding the indexes at regular intervals for better performance
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance
  • Deploying new code base release to UAT and Production Environments.
  • Perform SQL Server service pack and Windows Service pack upgrades.
  • Working with customers on Application rollouts and server migrations.
  • Extensively worked on Enterprise Manager for managing the database
  • Troubleshoot performance problems and fine-tuning of databases.
  • Involved in Index Analysis and Performance Tuning.
  • Converting DTS packages into SQL Server 2005 Integration Services.
  • Migrating SQL Server 2000 data bases into SQL Server 2005.
  • Recovering the databases from backup in disasters
  • To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005/2008, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential

SQL DATABASE ADMINISTRATOR

Responsibilities

  • Monitoring the server for High availability of the servers.
  • Solving the request raised by user support.
  • Participate in implementation of new releases into production.
  • Facilitates application deployment and joint effort deployments.
  • Meet the SLA Service Level Agreement established.
  • Day-to-day administration of live SQL Servers.
  • Designed and implemented Security policy for SQL Servers
  • Used Stored Procedures, DTS packages, BCP for updating Servers
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers
  • Automated messaging services on server failures, for task completion and success
  • Execute procedures to accomplish short-term business goals.
  • Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
  • Deploying monitoring tools like Sitescope and spot light.
  • Table partitioning to improve I/O access
  • Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users
  • Using database level triggers code for database consistency, integrity and security.
  • Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.

Environment: SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.

Hire Now