Sql Server Dba Resume
Irving, TX
SUMMARY
- 7 Plus years of IT experience in the SQL Server DBA in Production, Development and Test Environments under Windows platforms And Development using Microsoft SQL Server and BI suite (SSAS,SSRS)
- 24 X 7 Production Database On Call Support.
- Installed SQL Server 2008 on Development and Test Environments.
- Expert in installation and configuration of MS SQL Server 2008/2005/2000/7.0 Databases.
- Experience on migrating the database fromSQL 2000 to SQL 2005 and SQL 2008.
- Created Mirroring, Replication and Log shipping for different customers
- Good technical knowledge in MS SQL Server development including, Microsoft Analysis Services, Reporting Services
- Experience in Database Backup, Recovery procedures
- Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication in SQL Server 2000 and SQL Server 2005 in OLTP Environments.
- Experience in installing and configuring SQL Server 2008/2005/2000 Clusters in Active/Passive.
- Production experience in Microsoft Cluster Services (MSCS), including Active/Passive, Active/Active, and Network Load Balancing clusters.
- Designing, Maintaining and Administering SQL Server Integration Service (SSIS) packages including Migrating and Redesigning SQL Server 2000 DTS Package into SQL Server 2005 SSIS (ETL).
- Expertise in creation and maintained of Procedures, Triggers and Functions.
- Extensive experience in Import, Export, Backup, Database monitoring tools.
- Experience in space allocation, database migrations and database security.
- Experience in Capacity planning, Performance Tuning, Disaster Recovery and troubleshooting.
- Extensive experience in backup and restore procedures.
- Planned, Implemented and monitored Database Mirroring.
- Experience in Installation, Configuration and Upgrading of SQL Server for Production, Development and Test Environment.
- Experience in controlling the user privileges, monitoring the security and Audit issues.
- In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
- Excellent communication skills, analytical skills, understand business requirements in various domains.
TECHNICAL SKILLS
Database: SQL Server 7.0,2000, 2005/2008, 2008R2
Operating Systems: Windows 2000/2003, 2008 and Window NT
Programming Languages: MS SQL, PL/SQL, C#.Net, VB.Net,ASP.Net.
BI Suite: SSAS, ProClarity, SSRS, SSIS
PROFESSIONAL EXPERIENCE
Confidential, Irving, TX
SQL SERVER DBA
Responsibilities:
- 24 X 7 Production Database On Call Support.
- Remote Monitoring of SQL Server 2005/2008/2008 R2
- Good expertise in migration of MS SQL Server 2000 to MS SQL Server 2005/2008
- Configured database mail, Linked server and database mirroring as per the application requirement.
- Created Maintenance plan for regular database Full, Differential, and T-log backup.
- Planning and implementing the Snapshot and Transactional Replication of MS SQL Server Databases, successfully configured/administered transactional replication using MS SQL Server 2000/2005/2008 .
- Successfully implemented High-Availability solution in MS SQL Server 2005/2008/2008 R2
- Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
- Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
- Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
- Involved in resolving RAM,CPU,HARD DISK AND NET WORK bottle necks issues
- Installed and configured SSRS (SQL server Reporting services).
- Expertise in implementing Integrated Installation of SQL server 2008 failover cluster on two nodes and performed failover test to ensure automatic failover
- Production experience in Microsoft Cluster Services (MSCS), including Active/Passive, Active/Active, and Network Load Balancing clusters.
- Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- I've set up few systems to use Kerberos
- Scheduling SSIS jobs (SQL Agent), Migrating DTS packages to SSIS packages.
- Involved in designing SSAS Cubes and Deploying Cubes on Production server
- Involved in designing in SSRS reports based OLAP and OLTP systems.
- 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.
- Manage and maintain database changes in Development, QA, Staging and Production
- Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
- Analyzed long running /slow queries and tune the same to optimize application and system performance.
- Experience in writing complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.
- Worked on Performance analysis and evaluation of queries and databases in slow running applications.
- Responsible for enhancing database objects including Tables, Indexes, and Stored Procedures and SQL jobs.
- Developed custom selection of reports ordering using SQL Server Reporting Services(SSRS)
Environment: s: SQL Server 2005/2008/2008 R2, Windows 2000, 2003/2008, T-SQL, SQL LiteSpeed, SQL Spotlight and VSS, SSAS, SSRS, SSIS, EXCEL 2007.
Confidential, Dallas, TX
SQL SERVER DBA
Responsibilities:
- Managing the production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
- 24 X 7 Production Database On Call Support.
- Migrated the existing Servers from SQL Server 2005 To Sql Server 2008/2008R2.
- Providing consultation and advice to application development groups to ensure that development efforts do not negatively affect production systems.
- Tuned Production, Development and Test database servers to ensure optimum performance.
- Providing performance reviews and tuning recommendations for applications.
- Providing primary DBA support for existing MS SQL Server environments and applications.
- Proactively monitoring system events and error logs as well as disk drive space available to databases and transaction logs.
- Migrated DTS packages to SSIS packages using DTS exchange tool.
- Developed SSIS Packages to transform data from excel/Access file to SQL Server database.
- Worked on clustered environment
- Involved in implementation of replications like Snapshot and Transactional replications.
- Proactively monitoring and analyzed system performance.
- Installed, configured and maintained SQL Server Clustering on two nodes and multiple nodes and performed failover process from active to passive nodes and managed the SQL resources.
- Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
- Experience in Installing and Configuring SQL Server Active/Active and Active/Passive clusters.
- Configured database mail, Linked server and database mirroring as per the application requirement.
- Created Maintenance plan for regular database Full, Differential, and T-log backup.
- Monitoring database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
- Coordinated database server maintenance and patching, and implemented infrastructure changes.
- Planned, implemented, tested and documented backup and recovery procedures.
- Participated in disaster recovery exercises.
- Communicated regularly with internal technical staff to ensure the database integrity and security.
- Scheduled and monitored all maintenance activities of SQL Server 2005/2008/2008 R2 including database consistency check, and index de-fragmentation.
- Tested and implemented new releases of SQL Server-related software.
- Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
- Managed reports using Report Manager and deployed reports using SSRS.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Configured securities and access to product databases in SQL Server 2005, Windows 2003 Server.
- Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers.
Environment: MSSQL Server 2005/2008/2008 R2,SharePoint Server 2010,TeraData,Erwin,Oracle,Excel,T-SQL, SSAS, SSIS Packages, SSRS, OLAP, OLTP, Windows 2003 Server
Confidential, Austin, TX
SQL SERVER DBA
Responsibilities:
- Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
- Monitor and troubleshoot SSIS Jobs and other tools.
- Configured database mail, Linked server and database mirroring as per the application requirement.
- Created Maintenance plan for regular database Full, Differential, and T-log backup.
- Remote Monitoring of SQL Server 2005/2008
- 24 X 7 Production Database On Call Support.
- Involved in setting up, managing and maintaining High availability technologies: Log shipping, Mirroring and Replication.
- Involved in implementation of replications like Snapshot and Transactional.
- Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
- Performed Database backups (operating system, flat file backups & export/import).
- Used Snapshot replication for creating multiple instances of a database for distributing the workload.
- Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance
- Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
- Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
- Migrated the existing Servers from SQL Server /2008R2.
- Create and manage SSIS packages
- Migrated databases over 1TB from SQL server /2008R2 with minimum down time.
- Monitor and tune both server and databases using DBCC, Server configurations options (sp configure) and Database options (sp dboption). Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.
- Manage and maintain database changes in Development, QA, Staging and Production
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Creating Replication and Log shipping for different Applications.
Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS),TOAD,, MS PowerPoint, MS Access 2003 & Windows Server 2003/2005/2008 , Oracle.
Confidential, Ohio
SQL SERVER DBA
Responsibilities:
- Involved in Migrated database from SQL Server 2000 to SQL server 2005 and Sql Server .
- Migrated databases over 1TB from SQL 2000 to SQL server 2005 with minimum down time.
- 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.
- Installed SP2 and 3045 hot fix upgrade to all the SQL server 2005 servers.
- Configured Log shipping and Transactional Replication for the mission critical application.
- Configured database mail, Linked server and database mirroring as per the application requirement.
- Created Maintenance plan for regular database Full, Differential, and T-log backup.
- Create Maintenance planes for Database integrity checks and Index-rebuild on a Regular basis to maintain good database health.
- Installed and configured SSRS (SQL server Reporting services).
- Regular Health Check Process for the production databases
- SQL Server - Error Log Review, Space Check, Backup Verification, Standby verification, DBCC Checks.
- Designed cubes with star schema using SQL Server Analysis Services (SSAS).
- Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
Environment: SQL Server 2000/2005/2008 , Windows 2000/2003 and 2008,SSIS,SSAS,SSRS, Oracle, TOAD, Excel 2007,Proclarity.
Confidential
Jr SQL SERVER DBA
Responsibilities:
- Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
- Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
- Involved in Upgraded the existing Servers from SQL Server 2000 to SQL Server 2005.
- Monitor and tune both server and databases using DBCC, Server configurations options (sp configure) and Database options (sp dboption).
- Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise manager, Erwin, MS PowerPoint, Windows Server 2000/2003 Servers.