Sql Server Dba Resume
NY
SUMMARY
- Around 10+ years of experience in Database Administration for very large and complex databases in SQL Server 2012, SQL Server 2008 R 2/ 2005/2000/7/6.5.
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
- Expertise in T - SQL writing stored procedures, triggers and functions.
- Administering SQL Server High Availability and Disaster Recovery strategies.
- Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
- Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing,
- Worked on logical and physical data base modeling with ERWIN tools
- Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
- Experience in Disaster Recovery Planning and Security Management operations.
- Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
- Having hands on experience in DR processes including Log shipping and Database Mirroring.
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects.
- Worked on SQL Server 2012 migration from SQL Server .
- Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
- Having Experience on Microsoft PDW for Data Warehouse
- Experience in Batch processes, Import, Export, Backup, Database Monitoring tools like Solar Winds and Application support.
- Created Linked Servers for SQL Server 2005 and 2008 R2
- Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS)
- Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
- Strong experience in mentoring team members and writing documentation.
- 24 X 7 Production Database on Call Support
TECHNICAL SKILLS
Databases: MS SQL Server 2012/ 2008/2005/2000/7, Oracle 10g /11g
Operating System: Windows 2008/2003 Advanced Server, Unix, Linux
Tools: SQL LiteSpeed, CommVault, SQL Native backup, Solarwinds, Spotlight
PROFESSIONAL EXPERIENCE
Confidential, New York
SQL Server DBA
Environment: is comprised of more than 80 Windows 2003/2008 Servers, running SQL Server 2005/2008/2012 in clustered, replicated environment
Responsibilities:
- To provide 24x7 production support for SQL Server databases (VLDB) on Clustered Servers to achieve maximum performance and uptime in production environment.
- Rebuilding / monitoring the indexes at regular intervals for better performance.
- Recovering the databases from backup in disasters.
- Involved in trouble shooting and fine-tuning of databases for its performance
- Logical and Physical Schema designs including the table design
- Facilitates application deployment and joint effort deployments.
- Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- To provide 24x7 production support for SQL Server databases on Clustered Servers with size up to 4 Terabytes to achieve maximum performance and uptime in production environment.
- 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.
- Performed installation of SQL Enterprise 2005/20 bit version on Windows 2003/2008 servers on Enterprise systems of clustered and standalone servers in enterprise Data Centers.
Confidential, Jersey City, NJ
SQL Server DBA
Responsibilities:
- Installation, configuration and maintenance of SQL Server 2000/2005
- Upgrade current applications to SQL 2005
- Day to Day Maintenance and resolve the system problems
- Software upgrade and Installation of the Service packs for SQL Server
- Work on SQL Server Clustering.
- Write Simple and Complex Queries using Transact SQL
- Creating Database, Indexes, Rules, and Defaults.
- Backup and Recovery procedures for production and development servers.
- Setup and maintaining the Replication server.
- Using DTS to Import and Export Data.
- Involved in 24x7 Production support.
- Database modeling using ERWIN.
Confidential, NY
SQL Server DBA
Responsibilities:
- Installation, configuration and maintenance of SQL Server 7.0/2000
- Day to Day Maintenance and resolve the system problems
- Data Analysis and Check the Integrity of the data.
- Work with SQL Server Enterprise Manager and Query Analyzer
- Write Simple and Complex Queries/ Stored Procedures using Transact SQL
- Create and Test DTS packages
- Manage SQL Server Cluster.
- Troubleshooting, Monitoring and Tuning the MS SQL Server for optimum performance.
- Work on Log Shipping instance of SQL Server.
- Backup and Recovery procedures for production and development servers.
- Setup and maintaining the Replication server.
- Involved in 24x7 Production supports.
Confidential, AUSTIN TX
SQL Server DBA
Environment: is comprised of 78 Win NT Servers/Win 2K Servers, running SQL Server 7 and 2000 in clustered, replicated environment. The main goal in this project was to keep the site up and running 24 hours a day.
Responsibilities:
- Installation, configuration and maintenance of SQL Server 7.0.
- Installation of SQL 2000 and Upgrade DB to SQL 2000 from existing 7.0.
- User Account creation, group creation and setting up privileges.
- Software upgrade and Installation of the Service packs for SQL Server
- Creating Database, Indexes, Rules, and Defaults.
- Used DTS to import an export data.
- Work with SQL Server Enterprise Manager and Query Analyzer
- Write Simple and Complex Queries using Transact SQL
- Backup and Recovery procedures for production and development servers.
- Creation of Triggers, Stored Procedure, Tables and Indexes.
- Performance monitoring and tuning SQL Server.
- Setup and maintaining the Replication server.
- Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for all the SQL Servers.
- Day to Day Maintenance and resolve the system problems
- Data Analysis and Check the Integrity of the data.
Confidential
Senior Officer Information Technology
Responsibilities:
- Installing SQL Server.
- User Account creation, group creation and setting up privileges.
- Planning the future hardware and software requirements.
- Providing day-to-day Administration tasks like Space Management, Log Management, Error Logs, Current Activities and Scheduled Tasks.
- Also involved in NT Administration.