PROFESSIONAL SUMMARY

• Over 7 years of professional experience in SQL SERVER Database Administration and Production Servers Maintenance.
• Expertise in Administration, Database Design, Performance Tuning, and Production Support for Large OLTP and Complex Databases.
• Extensive knowledge of Relational Database Management Systems with in depth knowledge of T-SQL.
• Very good understanding in SDLC Systems Development Life Cycle .
• Experience in installing and configuring SQL Server 2012, 2008R2, 2005, 2000.
• Migrated SQL Server 2008 to SQL Server 2012.
• Migrated SQL Server 2000/2005 to SQL Server 2012 and 2008 R2 versions.
• Experience in implementing Disaster Recovery and High Availability solutions using Replication, Log Shipping, Mirroring and Clustering.
• Hands on experience in Backup and Restoration of databases, Automation of administrative tasks using SQL Server Agent, Security Management and in Managing server and clients.
• Specific hands on experience in normalized and de-normalized database design.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Experience in Performance Tuning, Query Optimization, and Database Consistency Checks using DBCC Utilities.
• Experience in Monitoring Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, resolve Dead Locks/Long Running Queries, accessibility and efficiency.
• Experience in diagnosing and tuning the server for optimal performance using SQL Servers Dynamic Management Views DMVs
• Experience in writing T-SQL in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions.
• Experience in Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Hands on experience in analyzing query plans, using extended stored procedures, managing indexes and locks, and troubleshooting deadlocks.
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the databases.
• Expertise in different scenarios of OLTP, OLAP databases.
• Hands on experience in using Analysis Services SSAS , Reporting Services SSRS and Integration Services SSIS to manage data ware house environment.
• Experience in Batch processes, BCP, DTS and SSIS utilities to migrate data from Excel, Flat files, Oracle etc.
• Experience of working closely with development team to assist them in various problem-solving and troubleshooting of Web-based applications and Database objects.
• Hands on experience in resolving database performance issues, database capacity issues and distributed data issues
• Proficient with Client/Server tools like SQL Server Enterprise Manager, SQL Server management studio and Query Analyzer to Administer SQL Server.
• Experience in investigating and applying necessary SQL Server database service packs and patches
• Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients. Complete Administration of Microsoft SQL Server Databases has always been my primary responsibility.
• 24 X 7 Production Database on Call Support.
• Good understanding of team work. Strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

• Relational Databases RDBMS : SQL Server 2012/2008R2/2008/2005/2000/7.0, MS Access 2000
• SQL Server Tools Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Advisor Wizard, SSIS, SSRS, Surface Area Configuration Manager
• Programming SQL, TSQL, C / C , PLSQL
• Operating System Windows 2003/2000 Advanced Server, NT Windows 9x, Linux, AIX
• Network Topologies TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP
• Case Tools MS Office 2000/XP/2003, MS Excel 2000/XP/2003, MS Outlook 2000/2003, Visio

PROFESSIONAL EXPERIENCE

Confidential

Sr SQL Server DBA Development / Production

Responsibilities:

• Installed and Configured MS SQL Server 2012, 2008/2008R2/2005.
• Maintained documentation related to MS SQL Server Databases
• Prepared policy documents for Installation and Configuration of MS SQL Server 2012 R2
• Responsible for Database Backups Restoration, Backup strategies and scheduling Backups.
• Created and monitored Database maintenance plans for checking database integrity.
• Designed databases for different projects and resolve database issues.
• Implemented applications in ETL packages using SSIS 2008/2005 for data integration using OLE DB connection from flat files, Text file, Teradata using SSIS Configuring tools such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all.
• Developed OLAP Cubes using SSAS and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, and Calculations using multi-dimensional expression MDX .
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Addressed the Replication Issues. Created new replications, DTS packages to maintain high availability of the data between the servers.
• Performed UAT and DEV refreshes from production for users to validate and test data.
• Prepared Daily health check checklists for MS SQL Server databases.
• Designed new job process, new database maintenance plans and set up notifications for the same.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Created SSIS / DTS packages to pull data from Oracle and Flat Files.
• Created reports using power shell to check for failed jobs as part of daily health checks.
• Helped Application Admin team to troubleshoot connectivity issues by running SQL Server Server-side Traces.
• Configured and maintained Log shipping as a Disaster Recovery Plan.
• Installed Oracle Enterprise Manager Agents on SQL Server hosts and added SQL Server instances to Oracle Grid Control 11 for pro-active monitoring.
• Supporting the business 24 7, maintaining 99.999 uptimes, depending on the application and business SLA requirements.
• Created a mirrored database on the report server using Database Mirroring with High Performance Mode.
• Created cubes and dimensions SSAS for the analysis of sales in specific areas.
• Worked with other Technical Teams like Application Admin team, Server team and Network team to solve Performance and/or connectivity issues.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SSRS 2012R2
• Analyzed requirement of AWE on servers where it was feasible and enabled the same to resolve memory issues.
• Prepared and implemented revised and improved Backup Strategy to ensure minimum down time and effective use of available resources.
• Handled regular deployments to production servers.
• Helped in Index tuning.
• Effectively used MagicTSD as a ticketing system to update all the database administration- operational activities in Incident Management and Change Management.
• Worked as DMS Admin to handle routine maintenance tasks of Document Management System such as acknowledging and troubleshooting email alerts.

Environment: SQL Server 2012/2008R2/2008 with clustering, Oracle 11g, 10g, T-SQL, SSIS, SSRS, SSAS Windows 2008 R2, Active Directory,

Confidential

Sr SQL Server DBA / Developer

Responsibilities:

• Installed and Configured MS SQL Server 2008/2008R2.
• Performed daily tasks including backup and restore by using native SQL Server and Litespeed.
• Configured replication in SQL 2008 on test and production servers.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
• Installed, authored, and managed reports using SSRS 2008 Reporting Services.
• Configured Active/Active and Active/passive SQL Server Clusters.
• Configured transactional and snapshot replication.
• Maintained the database consistency with DMV and DMF's at regular intervals.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.
• Created cubes and dimensions SSAS for the analysis of sales in specific areas.
• Designed new job process, new database maintenance plans and set up notifications for the same.
• Created an extensive report to prevent the Backup Failures in the environment.
• Did trouble-shooting of Client connections, viewing error log and applications.
• Configured and maintained Log shipping as a Disaster Recovery Plan.
• Created Audit Report for SQL Server service accounts using Power Shell.
• Assisted in Tuning Procedural codes using Server Side Trace Queues.
• Monitored, set and controlled system capacity plan for future system requirements. Made recommendations for space management and monitoring.
• Creating reports using OLAP cubes, Dimensions, Facts, data source views, stored procedures and T-SQL, Developed MS OLAP cubes, OLAP reports and the schedules to populate the data.
• Data migrations using BCP, DTS and SSIS Packages across different databases like Oracle, DB2, MS access, MS Excel flat files.
• Worked with other Technical Teams like Citrix and SharePoint to resolve Performance Issues.
• Handled routine administration of SQL Server 2000/2005/2008.
• Resolved existing problem in SQL 2000 production box with the Log shipping getting out of sync by making design changes.
• Analyzed requirement of AWE on servers where it was feasible and enabled the same to resolve memory issues.
• Worked with OS team to identify and resolve .net and IIS issues on database servers.
• Initiated a process of Inventory Management of SQL Servers.
• Assisted development teams in running their data-fix scripts in production environment.
• Assisted development teams in deploying Reports on Production Servers.
• Configured and maintained database refresh from Production to UAT and Development Servers.
• Effectively used Remedy tool to update all the database administration- operational activities in Incident Management and Change Management.
• Good Understanding of following Change Management Procedures.

Environment: SQL Server 2008R2/2008/2005 with clustering, Lite speed, Oracle 10g, DB2, SSIS, SSRS, SSAS, T-SQL, Windows 2003, Active Directory, Remedy

Confidential

SQL Server DBA

Responsibilities:

• Installed and Configured MS SQL Server 2008.
• Migrated SQL Server 2005 data bases into SQL Server 2008.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Maintained Replication in SQL 2005/2008
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Maintained the database consistency with DMV and DMF's at regular intervals.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Dropped and recreated few tables for the damaged databases to avoid data loss.
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed Data partitioning and disaster recovery in SQL 2008.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Monitored servers using Spotlight third party software.
• Implemented Database Mirroring.
• Worked with Stored procedures, triggers, cursors etc
• Reviewed, designed and architected the data model using CA Erwin 7.2
• Transferred data ETL to Data ware house Environment using SSIS.
• Performed De fragmentation Techniques of most complex indexes.
• Planned for backup and recovery of database information using RMAN.
• Optimized the Disk space for performance using RAID and SAN.
• Used Log shipping for synchronization of database.
• Monitored, set and controlled system capacity plan for future system requirements. Made recommendations for space management and monitoring.
• Created test database environment and identifying test requirements.
• Worked with other Technical Teams to resolve Performance Issues.
• Handled routine administration of SQL Server 2005/2008.

Environment: SQL Server 2008/2005 with clustering, CA Erwin 7.2, Litespeed, T-SQL, Windows 2003, Autosys, Active Directory, Quest LiteSpeed.

Confidential

SQL Server DBA

Responsibilities:

• Installation of MS SQL 2008 servers on production, Test and Development boxes.
• Handling user requested issues through Service Tickets.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Installed 64 bit SQL Server 2008 on Windows 64 bit Operating System
• Successfully installed SQL servers 2008 on cluster server.
• Migrated SQL Server 2005 database to MS SQL Server 2008
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created SSIS Packages to migrate the data from database to Text files.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors
• Deployed builds in Production servers for schema changes and worked in CMR Change Management Request department.
• Successfully implemented Database Mirroring in SQL Server 2008
• Successfully Configured Snapshot, Transactional and Transactional with updatable subscription in Replication.
• Created Maintenance Plans for production servers Full, Differential and Transactional Backups using Litespeed.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Managing the VERITAS clustering environment.
• Generated various monthly reports with the help of SSRS 2008.
• Installation of 32 bit and 64 Oracle 10g client and applied DST Patches for Oracle Linked servers
• Created Linked servers for retrieving data from other Servers including Oracle
• Co-ordinating with the programmer analyst for optimizing query, writing stored procedures.
• Conducting Root Cause Analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency
• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
• Resolving Locking and Blocking issues by using various SQL server internal commands
• Scheduled and Monitored SQL jobs using SMA OpCon/xps
• Installation of Service Pack 2 and Hot fixes for SQL Server 2008

Environment : Windows Server 2008 Enterprise Edition, SQL Server 2008, SQL Server 2005, SSAS, SSIS, SSRS, OLAP, OLTP, ETL, Replication, Clustering, Litespeed 4.8.3.0025 .

Confidential

SQL Server DBA

Responsibilities:

• Converted Data Transformation Services DTS application to SQL Server Integrated Services SSIS as assigned.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services SSIS .
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Experience with configuration, load balancing, backup/recovery, sizing and space management, PL/SQL tuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager Tool.
• Worked on Migration of packages from DTS using SQL Server Reporting Service SSIS .
• Generating reports using SQL Reporting Services SSRS for customized and ad-hoc Queries.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Experience with configuration, load balancing, backup/recovery, sizing and space management, PL/SQL tuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager Tool.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server
• Created and Maintained SharePoint Site for Issues Tracking and Reporting Weekly Monthly Status Metrics
• Done CPU Performance tuning for the servers as disk space.
• Provides technical documentation of the system
• Code reviews to move it to the production developed by developers.
• Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.

Environment:- SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,, IIS 6.0, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service

Confidential

SQL server DBA

Responsibilities:

• Installed and configured different edition of SQL Server 2005 like Express edition, Enterprise edition with the latest service pack.
• Successfully migrated from SQL Server 2000 to SQL Server 2005 on Development and Testing Environment.
• Created SSIS packages for the extracting, transforming and loading the data from SQL Server 2005 and flat files.
• Converted all existing DTS package of MS SQL 2000 to SSIS packages by using package migration wizard and DePloyed new Package in different Server.
• Participate in Operational Calendar for maintaining DB for month and follow that Schedule
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Successfully implemented Database Mirroring in SQL Server 2005
• Successfully Configured Snapshot, Transactional and Transactional with updatable subscription in Replication.
• Created Maintenance Plans for production servers Full, Differential and Transactional Backups using Litespeed.
• Managed the VERITAS clustering environment.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Implemented different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Tested Environments and keep them updated.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system using diagnostic manager from Idera.
• Created logins and roles with the appropriate permissions.
• Monitored Analyzed SQL Log, Perform counters and Performance Tuning for all development and staging environment.
• Responsible for resolving blocking and locking issues.
• Successfully implemented database mirroring between Primary server and Mirror Server.
• Implemented log shipping in standby mode to support DR servers.
• Provided 24 X 7 dedicated supports for SQL Server production server

Environment: MS SQL Server 2000/2005, Enterprise Manager, and System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, SQL LiteSpeed, T-SQL, Windows 2003/2000 server, Window 2000