SUMMARY:

• Overall 12 years of IT experience in IT Infrastructure support projects with ITIL and Agile knowledge including 8 years of experience as SQL Server DBA.
• Experience in Designing, Installation, Configuration, Database Security and Query optimization for better performance.
• Own the Oracle, Confidential SQL and DB2 UDB/LUW Server environment including the design and implementation of strategies for operational/development support, monitoring, deployments, security, performance analysis and query optimization.
• Working knowledge of .Net Framework (VB.Net, ASP.Net, and ADO.Net) and IIS.
• Experienced in programming tasks Stored Procedures, Triggers and Cursors using SQL Server 2012/2008/2005/2000 with T - SQL
• Experience in Analyzing and troubleshooting OS/SQL server related problems, implementing solutions and options with attention to details and have the ability to communicate to management in an appropriate manner.
• Hands on experience in Migration of SQL Server 2005, 2008R2/2008 to SQL Server 2012 (side by side and in place) which includes production and non-production environment.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Experience in applying SQL server patches, hot fixes, cumulative updates and service packs in clustered and non-clustered environments.
• Lead a team and define project principles and guidelines for the team to adopt.
• Ability to multi task, meets deadlines, quickly adapt to different environments and work with different team sizes across geographical locations.
• Expertise in implementing various replication models such as Transactional and Snapshot.
• Experience in implementing disaster recovery plans and participated in Disaster Recovery testing.
• Experience in Performance Tuning and Query Optimization using Dynamic Management Views.
• Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Experience in designing enterprise-wide database backup and recovery plans.
• Expertise in designing security policies.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions..
• Experience in SQL Server Integration Services (SSIS) and Reporting Services (SSRS) implementation.
• Comprehensive experience in Change Management and ticketing system software such as Team track, peregrine ticketing tool, service center and Remedy.
• Provided 24x7 on call production support.
• Ability to multi task, meets deadlines, quickly adapt to different environments and work with different team sizes across geographical locations.
• Self-motivated team player with excellent verbal and writing communication skills.
• Domains: Financial Services, Energy, Manufacturing, Tech

TECHNICAL SKILLS:

Languages: T-SQL, XML, HTML Script

RDBMS: MS SQL Server 2012, 2008, 2005, 2000, MS-Access, Oracle 11 g, DB2

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Operating Systems: Windows 2008/2003/2000/ Professional/ NT 4.0 Advanced Server

Other Tools: Compaq Insight Manager, Idera Diagnostic Manager, MS system center operations Manager (SCOM), Red Gate, SQL Safe, light speed, Zabbix, Jenkins, Plutora.

Secondary Skills: IIS- Application server management and VMware setup and configuration.

PROFESSIONAL EXPERIENCE:

Confidential, Wisconsin

Sr. SQL SERVER DBA

Responsibilities:

• Installed SQL Server 2008 R2 on standalone and cluster environments.
• Involved in Migration of SQL 2005 to SQL server 2008 R2.
• Oracle 11g R12 database Installation, Administration, Upgrade, Patching & Migration, RMAN Backup and Recovery, Performance Tuning and Database Security in Oracle 11g on Windows Server 2008 R2 Operating System.
• Created and configured an OLTP Replication databases for disaster recovery purpose.
• Involved in implementation of replications like Snapshot and Transactional based on business needs.
• Performed all aspect of database administration, including backup, recovery, and replication for SQL server.
• Experience in Understanding structured data analysis, data models and data normalization.
• Configuring SSIS (SQL Server Integration Services) for named instances, remote access enabling for Users.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Solid experience with SQL 2008 R2 backup and recovery procedures.
• Creating and Maintaining Trace Audits for Security events and generating Reports to analyze the Events.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related issues.
• Exporting the Database from Local Server to the Remote Server and Importing the Current running database from remote server to the Local DB Server using SSIS.
• Developed SQL data migration scripts for application conversion or integration.
• Created various Jobs, scheduled & ran jobs and troubleshoot the failed jobs.
• Had good experience in 24/7 production support.
• Good understanding of developing Data Ware house applications using star schema approach.

Confidential, McLean, Virginia

Sr. SQL SERVER DBA

Responsibilities:

• Worked on migrating SQL server 2005/2008/2008 R2 to SQL server 2012.
• Experience in managing very large databases (more than 3 TB).
• Applied patching provided by Third party vendor for different applications.
• Participated in Storage, Capacity Planning, Forecasting and Configurations for various applications.
• Responsible for deploying scripts, only when CO (change order) is accepted and approved by DBA manager.
• Manage day to day workload and activities, while aligning resources and managing the workload of the team
• Created Database and DB maintenance plans according to banking compliance and monitored it.
• Recovering the database from backup in disasters. Implementing point-in-time recovery solutions.
• Responsible for Remediating Nezumi (security) violations and maintaining as per standards.
• Participate in bi-monthly planning meeting to set the Project objectives for the upcoming cycle
• Created Database Snapshot in Pre-prod before making changes in the database.
• Database Refresh from Production backup to Stage and Development environments
• Creating monthly metrics reports for resource utilization in Projects and forecasting future requirements from clients.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Experience in database upgrades and applying service packs.
• Performance tuning of application and Analyzing long running queries and tune the same to optimize application and system performance.
• Created and scheduled jobs for update stats, rebuild index, database backups to automate day to day/maintenance activities.
• Involved in creating Table partitions for large tables for performance improvement.
• Created SQL/Windows logins and assigned necessary permissions as required.
• Migrated data from SQL to Oracle using SSIS as per application team request.
• Coordinate with various Application teams for major Database changes and help with creation of Scripts as required and validate it.
• Monitoring the server and database to detect any problems in the performance or connections, especially if an error was notified by the application team in all environments.
• Using query execution plan and profiler to diagnose SQL SERVER databases performance issues.
• Replication - Configured and maintained Transactional replication.
• Involved in various DBA activities like taking backups and restore as per application need, creation of logins with necessary permissions, creating disk space reports, memory and connection issues, blocking and file growth issues etc.
• Ensuring team participation & contribution to KM activities
• Maintain the Knowledge base of process learning

Environment: SQL Server, 2008, 2008 R2, 2005, SSIS and SSRS..NET Framework, ASP .NET, Idera,Oracle 11g, DB2, Windows server 2003, 2008.

Confidential

Sr. SQL SERVER DBA

Responsibilities:

• Implemented data models, database structure design, backup and recovery processes.
• Configured Change Data Capture in SQL Server 2008 to maintain the history of the changes in the tables.
• Extensively worked on migrating SQL server 2005 to SQL server 2008 R2.
• Involved in installation of SQL Server 2008 R2 on Consolidated and Standalone environments and maintains development and production databases (e.g., SQL Server databases).
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Audits and maintains small-scale to large-scale databases.
• Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
• Responsible for verifying all data to be entered into database meets set standards and requirements.
• Involved in creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.
• Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Worked on DTS Packages, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• In Depth knowledge in analyzing Query Plans, Extended Stored Procedures and improving efficiency by re-indexing, update statistics, Recompiling stored procedures, Troubleshooting Dead Locks and capture data using SQL Profiler, Performance Monitor and DBCC Commands.
• Identifies tests and resolves complex database issues (e.g., monitoring and tuning).
• Involved in database system management functions (e.g., software installs, version upgrades and configuration management).
• Defined and provided recommendations database standards, procedures and architecture.
• Participated in a 24x7 production support on-call rotation.
• Worked with Database tools IDERA, SQL Diagnostic manager, Sites cope for Multi Queries, Space analyzer, SQL alerts(Disk space alerts, SQL Service alerts, CPU utilization alerts).
• Involved in Ensuring optimal performance and availability of databases.
• Involved in creating SQL jobs and troubleshoot failed jobs.

Environment: SQL Server 2008 R2, 2005, SSIS and SSRS, Sites Scope monitoring tool,SCOM, IDERA tool, VMware machines, .NET Framework, ASP .NET, Visual Studio .NET, HTML, XML,Windows server 2003, 2008.

Confidential

SQL SERVER DBA

Responsibilities:

• Administration of Database and Web activities in Application environments.
• Co-ordinate with the release manager on upcoming releases on applications.
• Participate in the review meetings and prepare plans for release in Test, Dev, Pre-production and production environment
• Work on the Change Request (CR’s) as per the Release.
• Preparation and Execution of quarterly release plans for integrated environments
• Hosting the Application Websites on IIS Server.
• Application SQL / IIS Server rebuilds, refresh & maintenance.
• Troubleshoot Website Connectivity & Performance Issues.
• Take part in Application and technology upgrades
• Create Database roles, Logins and assign permissions as per the business requirement.
• Create, Manage, verify and import Server Certificates.
• Setting up replication between Environments.
• Building of New Web Servers and Migration of the applications from one environment to other.
• Maintaining of Backup Strategies as per the standards defined by client using SQL LiteSpeed.
• Applying Windows, office and other security patches.
• Fixing failures with - Replication / Database/Disk Space/Capacity & State Change Issues / Service Outages (SQL Agent; Server; etc) / SQL Connectivity & Linked Server Issues
• Applying Hot fixes, builds, Cumulative updates on servers as appropriate.
• Assisting Development and Test teams for releases on pre-production and Production environments.
• Coordinating with internal and external teams to resolve technical and environmental issues.

Environment: SQL Server2008 2005, Lite Speed,Windows server 2003, 2008.

Confidential

Sr. Support Analyst

Responsibilities:

• Scope of work includes network related, Internet Connectivity issues, Configuring email clients and printer configuration.
• Managed Team of Six L1 Engineers.
• Handle L2 Escalation from support engineers.
• Point of contact for handling Customer Escalations.
• Co-coordinating with Various Vendors.
• Experience in Understanding structured data analysis, data models and data normalization.
• Solid experience with SQL backup and recovery procedures.
• Creating and Maintaining Trace Audits for Security events and generating Reports to analyze the Events.
• Developed SQL data migration scripts for application conversion or integration.
• Created various Jobs, scheduled & ran jobs and troubleshooting failed jobs.
• Had good experience in 24/7 production support.

Environment: Windows server 2000/2003, SQL Server 2005

Confidential

Analyst and Lead

Responsibilities:

• Providing both Voice and Email L1 Desktop Support.
• Troubleshoot Desktop network Components like Network Interface card, browser support like Internet Explorer, Netscape.
• Take Remote access of the Desktop by using VNC to troubleshoot issues.
• Responsible for assigning the calls to the engineers based on the individuals technical expertise.
• Building long term relationship with existing customers.
• Mentoring the new hires.
• Involved in Capacity Planning.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Working with ITSM Tickets (Any changes on Production, staging and development environment need to Create ITSM Tickets).
• Maintained the Tax System databases.

Environment: Windows 2003/2000