SUMMARY

• Having 7+ years IT experience as a SQL Server DBA, Seeking a SQL server DBA position with new challenges and opportunities to build upon my extensive knowledge and experience in MS SQL Server in the areas of Installation, Configuration, Development, Replication, Maintenance, Performance tuning, Security, Data Transformation in Production and Development environments.
• Extensive experience in installation and configuration of MS SQL Server 2008 R2/20 and 32 bit).
• Expertise in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
• Migration experience with multiple databases/servers from SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008, SQL, DTS to SSIS Packages.
• Proficient in developing, debugging, deploying SSIS Packages using SSIS designer in Business Intelligence Development Studio (BIDS) for integrating data from heterogeneous sources (MS Excel, Oracle, Flat Files etc.).
• Thorough knowledge on SAN environments, RAID levels.
• Experience in Data Modeling using MS Visio and Erwin.
• Experience in developing Stored Procedures, Functions and Triggers in MS SQL Server 2008/2005/2000 .
• Experience and Knowledge on High availability& Disaster Recoveryoptions like Replication/log shipping/Mirroring, in clustered environment (active / passive) to further increase scalability and stability of business critical systems.
• Database Maintenance Plan design to keep track of the performance of MS SQL Server, which covers updating database statistics and Re - indexing of clustered and non-clustered indexes in production environment.
• Involved in working with VLDB (very large databases) and writing Dynamic SQL Statements.
• Implemented new features of SQL Server 2008 such as Filtered Indexes, Partition Aligned Indexed Views and Backup Compressions.
• Thorough understanding of tools like Toad, SQL Profiler, DTA, DBArtisan, Lite Speed etc.
• Involved in creating Standard and Ad-Hoc (Table, Chart and Matrix) reports using SQL Server Reporting Services (SSRS).
• Experience in troubleshooting database issues using DBCC commands.
• Expert in constructing triggers, stored procedures, user functions, views, indexes, user profiles, data dictionaries, and data integrity using T- SQL.
• Involved in designing Star Schema and cubes.
• Extensive knowledge in developing and deploying ETL packages using, DTS, Informatica, SSIS for accessing heterogeneous data, data cleansing and auditing.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Expert in using MS SQL Server tools SSIS, SSRS, and SSAS.
• Used ProClarity server to create interactive reports with an ability to drill down into details.
• Strong analytical ability coupled with excellent written and verbal communication skills.
• Strong Leadership skills, energetic, self-starter, quick learner and a team player.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003/2008, Windows XP/ 2000/ 95/ NT, UNIX.

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SQL Server Management Studio, Vm Ware, SSIS, SSRS, SSAS

Databases: MS SQL Server 2012/2010/2008/2008 r / 7.0, Oracle 10g Expression, MS Access

Languages: My SQL, SQL, Oracle PL/SQL, T-SQL, C, Ms-Word, Excel, Power Point.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installation of the 2008 R2 on New Production and Test servers with latest Security updates involving Service Packs and Security patches.
• Creating and managing schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Responsible for enumerating instances of SQL Server and Bulk copy operations using .Net framework data provider.
• Day-to-day activities like taking Backup (or schedule the backups daily/weekly/monthly for database using Red gate SQL backup tool) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Defined report layouts including report parameters, Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005/2008.
• Monitored performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Experience in Migration from SQL Server 2000 to SQL Server 2005 and SQL server as well as DTS Xchange tool for migrating DTS packages to SSIS packages.
• Created Logins and Roles and managed security and permission on different database objects
• Worked on Common Table Expressions (CTEs) which makes a reusable expression part of a query.
• Implemented and successfully tested Log Shipping and Database Mirroring in SQL Server 2005 and SQL Server 2008.
• Involved in using .NET Framework applications to request notifications when the data has changed in the underlying database.
• Involved in Performance tuning with the help of SQL Server Profiler, Database Engine Tuning advisor & windows performance monitor to retrieve the least performing queries and mostly utilized queries.
• Working knowledge on the SQL Server Query Optimizer which will correctly evaluate a query and run it as optimally as possible.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Involved in using SQL Profiler to identify slow running queries and stored procedures, least and mostly used stored procedures.
• Maintaining the database consistency with DBCC like checkdb, checkalloc, shrink file, and shrink database at regular intervals.
• Implemented Transactional Replication, Marge Replication depending upon the requirements.
• Responsible for using Transparent Data Encryption for a full database level encryption that protects the data files and log files.
• Created and schedule Maintenance Plans on the production databases.
• Involved in database designing using Normalization.
• Used different kinds of SQL Joins to join more than 10 tables.
• Created indexes on Selective Columns to speed up queries and analyses in SQL Server Management Studio.
• Deployed and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Involved in designing Star Schema, Snowflake Schema and Created Cubes.

Environment: Windows 2008 Servers, MS SQL Server 2012/2010/2008 R2/2005, SQL Query Analyzer, MS SQL Server Integration Services(SSIS), Database Tuning advisor, MS SQL Configuration services, TOAD, SQL Lite Speed, Red Gate, SQL Profiler, T-SQL, SQL Server Reporting Services(SSRS), Business Intelligence Development Studio.

Confidential, Topeka, KS

Sr. SQL Server DBA

Responsibilities:

• Performed migration of servers from SQL Server .
• Monitored replication and configured servers for Publishers, Subscribers, and Distributor for Marge and transactional replication.
• Tuned T-SQL code using optimization techniques to improve query response time.
• Rebuilt indexes at regular intervals for better performance.
• Involved in designing the databases using Erwin.
• Detached database from Sql server 2005 and attached to Sql Server 2008 using SSMS.
• Setting up a QA Environment with SQL Server 2005/2008 Database Server for the complete application testing.
• Involved in configuring Microsoft Cluster Service (MSCS), and review network, security, and considerations for other software that will run on the failover cluster.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Involved in implementing Marge and Transactional Replication.
• Defined constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc), rules and defaults.
• Data migration from Text to SQL Server using BCP command line utility and Bulk insert.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Participated in testing and debugging of SQL queries.
• Created Service Broker Programs to continuously load data from the mirror database to the report database.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Implementation of fail over clustering on warm stand by servers and raid 1 - 5 technologies.
• Created SSIS packages to pull data from Oracle to Flat Files and Excel.
• Generated different reports using MS SQL Reporting Services.
• Analyzed the requirements and selected the appropriate Fact tables/created Fact tables and Dimension tables.

Environment: MS SQL Server 2008/2005/2000, Windows 2003/2000/NT, SQL Profiler, SQL Server Management Studio SSIS, SSRS, Database Tuning Advisor, Service Broker, Raid, Oracle 9i,BCP Utility, Excel .

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Upgrading and Installation, creating and managing databases, integrating MS SQL Server and Windows 2008.
• Involved in creating SQL server logins, creating roles, granting privileges, unlocked accounts, reset passwords for developers and users.
• Responsible for Database backups & Restoration, Backup policies, scheduling backups.
• Extensively Developed SQL scripts for Maintaining Administration tasks.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages.
• Created Indexes on columns of a table for better performance of queries and stored procedures.
• Working knowledge on implementing and troubleshooting Active/Passive clustering on SQL Server 2008.
• Created Database Snapshots for protecting servers from user and administration errors.
• Responsible for writing & Editing Stored Procedures, Triggers, Views, Tables & T-SQL Scripts.
• Performed Database Design, Data Modeling using Erwin.
• Scheduled maintenance Jobs and Alerts using SQL Server Agent by creating database maintenance plans.
• In depth knowledge working with Windows, SQL, Clustering, and infrastructure environments.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Implementing and planning and monitoring of Log Shipping for different databases as disaster recovery solution.
• Involved in adding and removing nodes in a SQL Server failover cluster in Active/Passive and Active/Active Clustering environment..
• Created a mirrored database on the report server using Database Mirroring with High Performance Mode to generate reports using MS SQL Server Reporting Services (SSRS).
• Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
• Successful in implementing and setting up the Replication (Transactional and Marge).
• Handled corrupt databases diagnosed & repaired them and were involved to transfer the OLTP data to Data Warehouse.
• Implemented the error threshold using Precedence Constraints and variables in SSIS Packages, using business rules as reference.
• Incorporating Business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted dataand rebuilding the relationship.

Environment: Windows 2008, SQL Server 2008/2005/2000, SQL Profiler, Business Intelligence Development Studio (BIDS), Erwin, SAN, SSIS, SSRS, T-SQL.

Confidential, Overland Park, KS

SQL Server DBA

Responsibilities:

• Replicated SQL servers handling thousands oftransactionsper day with 24/7 uptime to service clients.
• Actively involved in Creation of database, modified tables, triggers, andstore procedures to clean and validate the data to meet the company specifications.
• Independently upgraded all the servers from MS SQL Server 2000 to MS SQL Server 2005.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Used BCP utility to publish table output to text files.
• Implemented Constraints on tables for maintaining Data Integrity.
• Tuned Stored Procedures, DTS packages for accuracy of Servers.
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Participated in testing and debugging of SQL queries.
• Created distributed partitioned tables, partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones.
• Implemented day-to-day operations such as database creation, monitoring disk space, monitoring performance using Profiler, implementation, testing, maintenance, and troubleshooting of software applications.
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.

Environment: T-SQL, MS SQL Server 2005/2000/7.0, BCP utility, DTS, Windows 2003/2000/NT, Sybase, ERStudio.

Confidential

SQL Server DBA

Responsibilities:

• Created and maintained Windows NT user profiles.
• Installed and configured MS SQL Server 2005 on Windows NT machines.
• Created and managed tables, functions, indexes using T-SQL in development and Production environment.
• Developed stored procedures, triggers and functions based on project requirements.
• Created all administration tasks of SQL Server and designed database.
• Designed report on the monitoring of SQL Server Performance using MS Access.
• Created DTS package to export and import data from SQL Server to Access, text files and Excel files.
• Created automatically running stored procedures for day-end operation using SQL Server agent.
• Support and maintenance of existing code and analyzing the impact of changes in scripts and data model.

Environment: MS SQL Server 2005/2000, T-SQL, SQL Query Analyzer, Windows NT, Profiler, DTS, Microsoft Excel

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirements, and implemented new design into SQL Server 2000.
• Succeeded migrating old data from legacy system into SQL Server 2000 using DTS and Backup and Restore option.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).
• Created Users and Roles, and managed security and permission of database.
• Created stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects.
• Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2000 Enterprise Edition