Sql Server Dba Resume
Cincinnati, OH
SUMMARY:
- 8+ years of Administration, Data Architect and Development using SQL server 7.0/ 2000/2005/2008 /2008 R2 systems in OLTP and OLAP environment.
- Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
- Migrating from SQL Server 2000 to SQL Server 2005 by In - place upgrade process and as well as side-by-side upgrade process.
- Installed and administered two node Active/Active cluster on MS Windows Server.
- Implemented side by side Migration of MS SQL server 2000 to 200 5/2008R2 and applied Patches and Service packs to update different versions of MS SQL server.
- Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
- Configured more than 2 GB of RAM on 32 bit clustered and standalone environments.
- Handled up to 700GB Size databases in clustered and Log shipping environment
- Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Object Search, Object Explorer Details, Activity Monitor, Multi Server Query, Intellisense in Query Editor and T-SQL Debugger.
- Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, ATTACH/DETACH Data Migration tools.
- Expertise in RDBMS S/w Installation, applying patches, upgrading, configuring, managing, monitoring disk space usage, database integrity/consistency and troubleshooting of SQL Server 2008 R2/05/00 on Windows 2008/03/00 servers built on Clustered & stand alone servers.
- Expertise in implementing and setting up DISASTER RECOVERY and HIGH AVAILABLITY solutions like Log Shipping, Mirroring and Replication ( Transactional and Snapshot Replication )
- Experience in creating and deploying the CUBES in BIDS with Fact and Dimension Tables using different data warehouse styles (star and snow-flake schema).
- Explicitly used third party tools like Litespeed, Fog light and Red gate.
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMVs and DMFs.
- Creating SSIS Packages using Complex Tasks like ActiveX script task, Fuzzy Lookup And fuzzy Groupings.
- Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
- Excellent skills in database Backup, Recovery, Linked Servers, Database Maintenance Planning.
- Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.
- Expertise in planning and implementing Database Security by creating users, Roles, and assigning permissions to them.
- Experience in creating and scheduling DTS and SSIS packages, SQL Mail Setup, Jobs, and Alerts.
- Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries and Common Table Expressions.
- Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
- Configure Database Mirroring in Cluster Environment.
- Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
- Management of schemas, Data modeling, objects & partitioning the tables & indexes.
- Configuration and Administration of Share Point 2007 .
- 24 X 7 Production Database on Call Support.
- Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
TECHNICAL SKILLS:
RDBMS: MS SQL Server 7.0/ 2000/2005/2008 /2008 R2, Access, Oracle9.0.
Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Crystal Reports 9.0/10.
Programming Languages: SQL, TSQL, VB.NET, XML, C++, Java, VB 6.0,ASP.NET
ETL Tools: DTS,SSIS,Informatica
Tools: Microsoft Office SharePoint Server 2007 (MOSS 2007), Windows SharePoint Services 3.0 (WSS 3.0), MS Office 2000/2003, MS Excel 2000/XP/2003, MS Outlook 2000/2003, Erwin, MS Visio.
Backup and Monitoring Tools: VERITAS Net Backup, Litespeed, Spotlight, Fog light.Operating systems: Windows 95/98/Me/XP/NT/2000, Unix, DOS, Linux, Windows Server 2003 /2008 .
PROFESSIONAL EXPERIENCE:
Confidential, Cincinnati, OH
SQL Server DBA
Responsibilities:
- Worked on Client/Server tools like SQL Server Management studio (2000), SQL Server Enterprise Manager (2008R2) and Query Analyzer to Administer SQL Server.
- Migrated SQL server 2000 databases into SQL server 2008R2 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
- Migrated DTS packages into SSIS packages.
- Configured Transactional replication on migrated server.
- Involved in the migration of SQL Server 2000 databases to SQL Server 2008R2.
- Installed, authored, and managed reports using SQL Server 2008R2 Reporting Services.
- Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
- Managed trouble shooting of Client connections, viewing error log and applications.
- 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.
- Database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
- Worked on enhancing the application specific data sources and added new fields according to the requirement.
- Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
- Creating and implementing 2008R2 concepts like DMV’s, DMF’s, Data partitioning, online indexing.
- Configured more than 2 GB ram on 32 bit Environment.
- Tuned stored procedures by adding the try catch blocks for error handling.
- Removed excess indexing by using the index include clause.
- Implemented the online indexing on 24X7 environments.
- Created the documentation for issue diagnostics reports.
- Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
- Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
- Involved in DATA Analysis like Analyzing and Accessing collection of Data.
- SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain Plan, Auto trace, TKPROF and tuned them to suit SLA.
- To analyze long running slow queries and tune the same to optimize application and system performance.
- To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
- To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
- To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL , Windows 2003 64- bit, SQL/PL SQL, DTS, SSIS, Profiler, Litespeed.
Confidential, St Louis, MO
Technical Database Administrator
Responsibilities:
- SQL Server 2005 64- bit Failover Cluster Installation on Windows Server 2008 x64-bit.
- SQL Server 2008 Installation.
- Writing batch scripts to do automation of database tasks.
- Writing scripts to manage different servers for auditing purpose.
- Running packages as for system promotion requirements.
- Solving Memory Problem related with SSIS Packages.
- SQL Server Analysis Services 2000 installation and Reporting Services 2005 installations on existing SQL Server Instances and SQL Server 2005 installations.
- Performance tuning on different Production Servers.
- Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
- Running profiler to troubleshoot Blocking issues, Deadlocks issues and Slow running Queries.
- Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Solving memory related problems by changing server configuration settings.
- Rebuilding indexes with different fill factors and update statistics manually.
- Building Maintenance plans for database maintenance.
- Writing stored procedures as for business requirements.
- Backup and Restore databases.
- Moving Tempdb to different file location.
- Shrinking the data files as the space requirements.
- Effectively used PL/SQL advance features like collections, ref cursors, dynamic sql and bulk loading.
- Managing users and security.
- Managing schema objects, such as tables, indexes, and views.
- Making database backups and performing recovery when necessary.
- Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
- Used Team Foundation Server 2010 for maintaining source control, data collection, reporting , and project tracking
- Involved in Configuration and Administration of Share Point 2007 environment.
- 24 X 7 Production Database on Call Support.
Environment: SQL Server 2000/2005, T-SQL, Windows 2003/2008 Server, Team Foundation Server 2010, Oracle 10g,Vb.net,Asp.net.
Confidential, Atlanta, GA
SQL Server DBA
Responsibilities:
- Managed and Administrated SQL SERVER 2008/2000 on highly transitive Production environment and Installed and setup SQL Server 2008 instances on clustered environment.
- 24x7 production support SQL server 2008 Database administration
- Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000 to 200 5/2008 on Windows.
- Implemented Transactional Replication on MS SQL server 2008 as a part of disaster recovery strategy
- Applied Service packs and patches and hot fixes on clustered nodes
- Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
- Configured the AWE and /3 GB switch for the 32 bit 2005 server.
- Applied Patches and Service packs to update different versions of MS SQL SERVER.
- Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
- Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA,SQLCMD and dedicated admin connection, Common table Expression(CTE).
- Moved files between the File Groups and partitioned the tables to improve the performance.
- Extensively used litespeed backup with MS SQL SERVER 2005/2008.
- Utilized the new features of 2008 like TDE, MERGE STATEMENT and Compressed Backups.
- Managed multiple MS SQL 2008 RDBMS on Web-based, transactional platform
- Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
- Documented and performed the data base health checks regularly.
- Created new tables, stored procedures and triggers IN T-SQL.
- Refactored and fine tuned the queries and stored procedures in TSQL.
- Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
- Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
- Rebuilding indexes with different fill factors and update statistics manually.
- Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
- Generated reports in SSRS using BIDS (Business Intelligence Development Studio)
- Rendered DRILL DOWN, STATIC reports in MATRIX form in SSRS
- Used SSIS packages to move data from dev to QA and QA to Production
- Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
- Deployed SSIS package for bulk insert and maintained archival data.
- Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
Environment: TSQL, MS SQL SERVER 2000/2005/2008 ,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS
Confidential, Roanoke, Virginia
SQL DBA / Developer
Responsibilities:
- Database Administrator/Database Programming/Product specialist.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
- Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
- Extensively worked on compliance issues.
- Wrote the packages using DTS in SQL2000.
- To analyze long running slow queries and tune the same to optimize application and system performance.
- Worked on key performance indicators for customizable metrics.
- To set up SQL Server configuration settings.
- Installed, authored, and managed reports using SQL Server 2000 Reporting Services.
- Monitoring SQL server performance using profiler to find performance and dead locks.
- Managed Disk space, memory and User connections.
- 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.
- Managing the clustering environment.
- Using log shipping for synchronization of database.
- To setup, implement, and maintain industry standards in database management.
- Monitoring SQL server performance using profiler to find performance and dead locks.
- Monitoring the servers using spot light third party Quest software.
- Maintaining the database consistency with DBCC at regular intervals.
- Implemented Data Access Layer using ADO.NET to communicate With the MS SQL Server 2005 Database.
- Involved in developing user controls and asp pages.
Environment: SQL Server 2000 with clustering, T-SQL, Windows 2003 Server, Oracle, VB.Net and ASP.Net.