SUMMARY

• 9+ years of experience in IT industry as a Microsoft SQL Server DBA
• Strong knowledge of Relational Database Management System concepts
• Proficient in all aspects of data modeling
• Good knowledge in drawing ER diagrams, Data Flow Diagrams/Process Diagrams
• Hands on Experience in installing, configuring, managing, monitoring, troubleshooting and maintenance of Microsoft SQL Server 2000, 2005, 2008, 2008 R2, 2012
• Experience with Database Backup - Recovery procedures & also Data Migration. Good understanding of Normalization, De-normalization and Normal Forms
• Hands on experience in designing and scheduling SQL Server Jobs, Maintenance plans for automating tasks and also in Capacity planning and database consolidation
• Hands on experience in designing databases, creating tables, indexes, views, clusters, user authorizations and security implementation
• Good development skills writing Stored procedures, User defined functions, views, cursors, triggers and complex queries as well as analyzing and debugging existing stored procedures
• Strong Transact-SQL Query writing skills (DDL & DML) and experienced in configuring linked servers to access heterogeneous databases
• Hands on experience in various Performance tuning tools
• Solid experience and outstanding knowledge of high availability SQL server solutions, using Replication (Transactional, Merge & Snapshot), Database Mirroring, Clustering, Log shipping and designing Disaster recovery plans
• Experience in Query Optimization, Client/Server, Connectivity, Database Consistency Checks using the various DBCC utilities and good knowledge of RAID configurations and SAN & NAS concepts
• Extensive experience in performing root cause analysis and using SQL profiler & PSS Diag for troubleshooting and using IDERA’s tools for performance and SQL Server activity monitoring
• Extensive experience, detailed knowledge of Assurance\Advisory, HealthCare, Regulation\Licensing Software solutions, Financial & Manufacturing Industries
• Knowledge in SSAS and its features which include OLAP cubes and Data Mining
• Experience in ETL Tools DTS and SSIS
• Experience in designing, configuring, deploying & generating reports using SSRS Ability to meet deadlines and handle pressure, responsibilities independently and as well as a proactive team member
• Excellent conceptual, analytical, communication, problem solving, decision making, writing and documentation skills

TECHNICAL SKILLS

Programming & Scripting languages: C, C++, HTML, XML, ADO.NET, MDX

Databases: Microsoft SQL Server (2000/ 2005/2008/2008 R2/2012), MS Access, Oracle

Database Tools: SSMS (SQL Server Management Studio), SQL Server Enterprise Manager, SQL Profiler, DTA, Query Analyzer, Index Analyzer, Backup and Restore, Replication, Log Shipping, Mirroring, SSAS, Dart secure FTP, IIS, Quest Central, Litespeed, Microsoft VSS, Idera’s SQL Diagnostic Manager, SQL Compliance Manager, SCOM, SQL Secure

Operating systems: Windows 98/NT/XP/VISTA/7, Windows Server 2000/ 2003/2008/2008 R2

ETL Tools: DTS (Data transformation services), SSIS (SQL Server Integration Services)

Development skills: SQL, Transact SQL (T-SQL), PL/SQL, Adobe Dreamweaver, DHTML

Data Modeling: CA ERWIN, MS Visio

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports

Web Servers: Apache, IBM Web sphere, IIS, Web logic, Tomcat

GUI Tools: Microsoft Visual Studio, Eclipse, Toad

Internet Protocols: TCP/IP, DNS, DHCP, FTP, SMTP, SOAP and POP3

Other Packages: Microsoft Office, VMware, HP SM9

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

MS SQL Database Administrator \ DB - Team Lead

Environment: MS SQL Server 2005/2008/2008 R2/2012 Standard & Enterprise Editions (32 bit & 64 bit), SQL Server 2008 R2 clustering, SQL Server Management Studio, SQL Profiler, SSIS, T-SQL, MS Office 2007, SSRS, HP Service Manager, SQL Secure, Windows 2008R2 clustering, Windows Server 2003/2008/2008 R2, SCOM Monitoring Tool, Replication Manager

Responsibilities:

• Involved in Installation, daily monitoring and maintenance of SQL Server 2005, 2008, 2008R2 & 2012 instances (32 bit & 64 bit) in the Production, Development, UAT & Test Environments
• Managed 265 database instances
• Managed databases of size ranging from as low as 80 GB to 18 TB databases
• DB Team lead for a team of 8 DBA’s working in 8 different projects (ENVOY, DCTM, GFS, MOBILITY, SERVICECATALOG, MYENGAGE, DOCPROD, BPM8 & REPORTING Projects)
• Production Support (24 X 7) & On call rotation
• Showcased the new Tools & Technologies of SQL Server to PWC
• Created SSIS packages for data migration between servers for ETL operations
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, security breaches and identified bottlenecks using SCOM tool
• Involved in the configuration of new SQL Server Instances on Windows servers with appropriate parameters and designed database consolidation strategies
• Responsible for the creation of new databases for various projects in PWC
• Created Stored procedures, User defined functions, triggers, constraints using T-SQL
• Designed & deployed Maintenance plans and scheduled SQL Server agent jobs
• Configured Resource Governor on PWC Reporting systems to efficiently manage the available resources for optimal performance
• Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Servers as per PWC security policies
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities, DMV’s and system procedures
• Used SCOM monitoring tool for monitoring SQL server Instances
• Configured & Administered database replication (Transactional) for PWC Envoy Reporting
• Automated Hourly Transactional Log, Daily Differential & Weekly Full database backups
• Used Replication Manager to manage VLDB database backups
• Used SQL profiler & PSS Diag for capturing useful data while troubleshooting performance issues
• Monitored the DB Servers utilization and performance during performance testing various application with the System Developers and Lead Testers
• Designed & Implemented SQL Server Reporting Services and also Created Reports using SQL Server Reporting Services (SSRS) for Confidential (PWC)
• Documented SQL Server Reporting Services
• Conducted Training sessions to teach the PWC users on how to Create, Deploy and Manage SQL Server Reporting Services (SSRS)

Confidential, Santa fe, NM

MS SQL Server DBA\SSRS - Team Lead

Environment: MS SQL Server 2000/2005/2008/ R2 Standard & Enterprise Editions (32 bit & 64 bit), SQL Server Management Studio, SQL Profiler, Oracle, Oracle Enterprise Manager, SSIS, T-SQL, SQL Server Clustering, MS Office 2003/2007, SSRS, SQL Diagnostic Manager, SQL Compliance Manager, SQL Secure, Windows Server 2000/2003/2008 , Windows XP/7

Responsibilities:

• Involved in Migration and Upgradation of Production Database Servers from SQL Server 2000 to SQL Server 2008 and also managed the location of database files, log files and their sizes. Migrated and validated users and logins in the new environment
• Involved in Installation, daily monitoring and maintenance of SQL Server 2000 & 2008 instances (32 bit & 64 bit) both in the Production and Development Environments.
• Involved in the configuration of new SQL Server Instances on Windows servers with appropriate parameters and designed database consolidation strategies
• Production Support (24 X 7) & On call rotation
• Involved in the change control process in the production environment
• Responsible for the creation of new databases, tables, indexes and views
• Modified existing databases based on performance and business requirements
• Created Stored procedures, User defined functions, triggers, constraints using T-SQL
• Created maintenance plans and scheduled SQL Server agent jobs
• Generated database SQL scripts and deployed databases including installation and configuration
• Involved in creating & securing Database Master Keys (DMK), Certificates & Service Master Key
• Implemented the leverage of Transparent Data Encryption (TDE) feature of SQL Server 2008 on Confidential Production State Host Server
• Did a case study of Encryption File System (EFS) feature of Windows Server 2003 and implemented EFS on Confidential Test Clinic Database servers
• Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2008 and the corresponding databases
• Used Idera’s monitoring tools like SQL Diagnostic manager for monitoring SQL server Instances and SQL Compliance Manager & SQL Secure to Capture, Audit and alert on SQL Server Activity
• Administered database replication (Transactional, Merge, Snapshot) between SQL Server database
• Automated and enhanced daily administrative tasks including space management, database backup and recovery
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, Database maintenance Plans and recovery
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities
• Used SQL profiler for troubleshooting
• Managed the production and development databases for performance tuning, capacity planning and database security configuration
• Created SSIS packages for data migration between servers and data import and export
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, security breaches and identified bottlenecks
• Backend testing with the System Developers and Lead Testers
• Designed & Implemented SQL Server Reporting Services (SSRS 2005, SSRS 2008, SSRS 2008R2) and also created several Reports using SQL Server Reporting Services (SSRS) for Confidential program
• Experience in installing and configuring SSRS 2005, SSRS 2008 & SSRS 2008R2
• Involved in upgrading SSRS 2005 to SSRS 2008 and 2008R2 versions
• Installed and configured TOAD to work with the KIVA oracle database
• Configured SSIS packages for ETL data from KIVA Oracle database to WIC ASC database
• Provided the Hardware and Software requirements for a VM server instance
• Configured Idera SQL Compliance Manager & SQL Secure to Capture, Audit and alert on SQL Server Activity
• Installed and configured SQL Server 2008 R2 Integration services (SSIS)
• Installed and configured SQL Server 2008 R 2 Reporting services (SSRS)
• Documented SQL Server Reporting Services procedures
• Conducted Training sessions to teach the New Mexico DOH WIC users on how to Create, Deploy and Manage reports in SQL Server Reporting Services (SSRS)

Confidential, St. Louis

MS SQL Server DBA

Environment: MS SQL Server 2008/2000, Windows 2008 Server, Windows 2000 Server, MS Integration Services, Diagnostic Manager, MS Reporting Services, AllFusion ErwinLitespeed

Responsibilities:

• Involved in Migration of Production Database Servers from SQL Server 2000 to SQL Server 2008
• Used AllFusion ERWIN to deploy any changes to the database and objects from test to production
• Implemented Database mirroring for High Availability
• Involved in Performance Tuning on Production, Staging and Test Servers
• Maintained various databases for Production and Testing SQL Server 2008
• Worked with SQL Server Auditing feature and new Activity Monitor for monitoring issues at database level as well as server level
• Involved in Monitoring Performance of different production servers
• Planning the location of data, index, and Transaction log files on the disk
• Performance tuning and Optimization of Stored Procedures and Queries
• Created the backup and restore strategy for production and development environment
• Planning the location of the Backup files on disk
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Involved in creating reports using SQL Server Reporting Services (SSRS) as per user requirement
• Migrated DTS packages to SSIS packages
• Experience in creating and executing SQL Server Integration Services (SSIS) packages
• Managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them as needed
• Used Litespeed for backing the databases and compressing them as needed
• Enforced policy based management at database level as well table level
• Implemented the leverage of Transparent Data Encryption (TDE) feature of SQL Server 2008
• Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups

Confidential, NJ, USA

MS SQL Server DBA

Environment: MS SQL server 2000, MS SQL Server 2005, Windows 2003, Enterprise managerDiagnostic Manager, Veritas backup solution, AllFusion Erwin, SQL Safe, HP MSAEMC Clarion CX3, DTS, SSIS, SQL profiler

Responsibilities:

• Installation of SQL Server 2005 with latest Service Packs
• Migrating/Upgrading to SQL Server 2005 from SQL Server 2000 environment
• Involved in Monitoring Performance of different production servers
• Involved with installation and maintenance of ACTIVE/ACTIVE Cluster Environments
• Disaster Recovery Plan, Testing and analyzing with documentation of all the scenarios
• Implemented Database mirroring for disaster recovery
• Created and maintained various databases for Production and Testing using SQL Server 2005. Planning the location of data, index, and Transaction log files on the disk
• Performance tuning, and optimization of procedures and queries
• Worked with SQL server Profiler
• Created complex stored procedures and functions to support efficient data storage and manipulation
• Maintained the Metadata between Test and Production servers through AllFusion ERwin
• Helped Development Team in deploying and testing the application, which uses SQL Server backend
• Created the backup and restore strategy for production and development environment
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Using Data Transformation Services (DTS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application
• Experience in creating and executing SQL Server Integration Services (SSIS) packages
• Migrating SQL Server 2000 DTS Packages to SQL Server 2005 SSIS Packages
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups
• Involved in Data modeling (Physical and Logical); designing and building relational databases
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles
• Reviewed security consideration for SQL Server 2005 installation
• Used BCP and Bulk Insert utilities
• Worked with SQL Server Reporting Services (SSRS)

Confidential

Jr. SQL Server Developer/DBA

Environment: MS SQL Server 2000, Enterprise manager, Query analyzer, T-SQL, VB scriptDTS, Crystal reports, windows server 2000

Responsibilities:

• Performed Installations and configuration of SQL server 2000
• Involved in designing and creating Tables, Static/Dynamic Stored Procedures and User defined Functions using T-SQL
• Created After and Instead of Triggers to enforce data consistency and integrity
• Involved in creating Views, Parameterized Views, Partitioned Views and Indexed Views
• Created Clustered and Non Clustered Indexes on tables
• Performed daily backup and restore operations with the help of T-SQL Scripts
• Carried out Performance tuning and troubleshooting of SQL queries and stored procedures using SQL Profiler, Query Plan (Graphical and Textual) and Statistics I/O
• Involved in the Quality Assurance process by performing testing and bug fixing
• Transferred data from various heterogeneous data sources like Excel, Fixed Width Flat Files, and MS Access to SQL Server 2000 using DTS and T-SQL Scripts
• Involved in generating reports using crystal reports