Sql Server Information Technology

Experience Summary:

IT professional with extensive experience in managing Databases for Information Technology, Financial Services and manufacturing industry. High integrity leader who develops strong partnerships with all levels of business and IT leaders. Core competencies and areas of expertise:

8+ yrs experience as SQL Server Database Administrator.

Hands on experience in installing, configuring, managing, administration, monitoring and troubleshooting SQL Server 2000/2005/2008/R2/2012, SSRS 2005/2008/R2/2012.

Experience in MS SQL Server suite of products with Business Intelligence in Report Server (SSRS), Integration Server (SSIS).

Experience in SQL Server version upgrade/migration 2000/2005/2008/R2/2012.

Experience in Migrating Oracle to SQL Server 2005/2008 using SSMA

Experience in implementing Backup and Recovery Strategies.

Experience in carrying out Archival & Purge plan for Database.

Experience in implementing Policy based management and EPM

Experience in implementing Resource Governor.

Designed & Implemented policies and processes related to: password security, configuration management, enhancements and Sarbanes Oxley Act (SOX) initiatives.

Solid working experience in SQL Server database administration and development performed with DBA duties all in enterprise environment.

Strong Knowledge in Performance tuning, database tuning techniques using monitoring tools like SQL Server profiler, system monitor, Extended events,.

Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.

Expert in automating process for proactive monitoring of Database servers.

Experience in Replication, Database Mirroring, and Log shipping.

Developed DTS and SSIS Packages from scratch to get the reports, routinely, in the excel sheets, required by the managers for analysis.

Migrating SQL Server DTS & SSIS packages to SQL Server 2005/2008/R2/2012 SSIS programs.

Working experience on Active Passive clustering model.

Experience in installation, upgrade and configuration of MS SQL Server in clustered and Non Clustered environments.

Experience in writing T-SQL (DDL, DML, DCL and TCL).Reviewing T-SQL code, maintaining coding standards across the board in all SQL Server environments.

Having expertise in maintaining 500+ databases at a time and data base size ranging from 1GB to 4TB.

Having experience of leading the modules and team of one to ten members, handling multiple tasks, prioritizing, assigning tasks, and coordinating different module teams.

Having experience in planning schedules for different modules, creating and tracking of Microsoft Project plans and Project status reports, and participated in project management meetings.

Project management expertise in leading individual modules and teams of one to ten members, handling multiple tasks, prioritizing, assigning tasks, and coordinating delivery team schedules.

Strengths include facilitating planning schedules, Microsoft Project plans and Project status reports, and pro-actively articulating risks and benefits to business and management teams.

Proven ability to multi-task on multiple diverse projects, and work independently to meet strict deadlines, yet flexible enough to be a team player in a team environment. Highly analytical, strong communication skills, detail-oriented yet able to look at a wide array of choices and identify what truly matters, ability and desire to quickly master new emerging organizational/technological changes and be calm in the face of fast-moving, changing and hectic environments

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2012/R2/2008/2005/2000, SSDS.

Database Tools: SSMS, Enterprise Manager, Query Analyzer, SQL Profiler, and Data

Transformation Services, Upgrade Wizard, Replication, Jobs and task creating and scheduling, SSIS, SSRS, Red Gate, SqlNexus, MAP tool.

Operating Systems: VMware, Windows R2/2008/2003, 2K, XP, Vista, Win 7

Programming Languages: VB 6.0, VB.NET, ASP.NET and T-SQL.

PROFESSIONAL EXPERIENCE

CITI Group, Dallas, TX Dec 2015 – Till Date

Role: Database Administrator

The company sells managed hosting and colocation services with 50 data centers (approximately 1.54 million square feet) in North America, Europe, and Asia, automated management and provisioning systems, and information technology consulting. Savvis has approximately 2,500 unique business and government customers.

Job Description:

I Worked as MS SQL DBA in Managed Hosting division. This department’s role is to manage Customer’s Databases, across the Globe consisting of 7000+ Sql Server instances.

Responsibility:

•Performed Database migrations from lower to higher SQL Server versions 32/64 bit machines

•Developed and implemented migration plans, including successful emergency cutovers.

•Performed & Involved in Archival & Purging Database Servers.

•Performed Capacity planning for both Farm servers (shared environment) and Individual Servers in the Data center and with the standard approvals and process, perform the needed enhancements.

•Developed, implemented, configured and maintained operational procedures and programs, including Disaster Recovery, System Security.

•Configured DR solutions for business critical applications, this involves Log shipping Replication & Database Mirroring.

•Performed DR practice tests for DataCenters outages regionally.

•Performed & Involved in Planning and implementing of various Backup & Recovery strategies.

•Actively involved in Performance tuning, database tuning using monitoring tools like SQL Server profiler, System monitor.

•Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

•Configured, Implemented multi-node SQL 2005/2008/R2/2012 clusters, Active\Active and Active\Passive configurations on 64 bit environments.

•Configured, Implemented Custom Replication for different Savvis Clients.

•Performed Database maintenance through a well engineered centralized process on all the Production servers.

• Developed reports using SQL 2005 SSRS for capacity and resource usage monitoring.

• Assisted in developing business critical SSIS packages for applications, related to various financial

instruments.

•Performed change control coordinator role, assess the impact, for a well-controlled production release mechanism.

•Managed and administered large volume SQL server databases ranging in Terabytes.

•Supported application developers and application implementation groups.

•Performed esteemed support as part of the follow the sun model, for three different time zones as part of 24*7, 365 support model. Provide 24*7 ONCALL support as per the scheduled routines

Target Corp, Minneapolis, MN Jan 2015 –Nov 2015

Role: Database Administrator

Target Corporation is an American retailing company. Target is the second largest discount retailer in the United States, behind Walmart. The company is ranked at number 30 on the Fortune 500 as of 2009, and is a component of the Standard & Poor's 500 index.

Job Description:

I am working as Primary DBA for Compliance & Engineering division. This department’s role is to ensure all databases are compliant as per defined standards and to manage all Target Databases, across the board. The most important task of my role is to protect critical data which fetches million dollars revenue.

Responsibility:

Configured, Implemented multi-node SQL 2005/2008 clusters, Active\Active and Active\Passive configurations on 32/64bit environments.

Performed Database migrations from SQL 2000 to SQL 2005/2008 32/64 bit machines.

Developed and implemented migration plans, including successful emergency cutovers.

Performed & Involved in Archival & Purging Database Servers.

Performed Capacity planning for both Farm servers (shared environment) and Individual Servers in the Data centre and with the standard approvals and process, perform the needed enhancements.

Performed & Involved in Planning and implementing of various Backup strategies.

Performed & involved in Sql Server Auditing (SOX, HIPPA, and GLBA).

Configured DR for business critical applications, this involves Log shipping Replication & Database Mirroring.

Performed DR practice tests for Data Centres outages regionally.

Implemented Enterprise Policy Based Management.

Developed monitoring modules to monitor all SQL Servers on the Enterprise level.

Actively involved in Performance tuning, database tuning using monitoring tools like SQL Server profiler, System monitor.

Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Performed SQL Server builds followed by standard QA process for various business critical applications and tuned them for optimal performance.

Configured, Implemented SQL 2000 & 2005/2008 Replication globally.

Performed Database maintenance through a well engineered centralized process on all the Production servers.

Performed change control coordinator role, assess the impact, for a well controlled production release mechanism.

Managed and administered large volume SQL server databases ranging in Terabytes.

Developed, implemented, configured and maintained operational procedures and programs, including disaster recovery, system security.

Supported application developers and application implementation groups.

Organized Level 1 DBA Team assigning tasks, with following up actions, to avoid maintenance noise issues, permanently out of the environment.

Performed esteemed support as part of the follow the sun model, for three different time zones as part of 24*7, 365 support model. Provide 24*7 ONCALL support as per the scheduled routines

Developed reports using SQL 2005 SSRS for capacity and resource usage monitoring.

Assisted in developing business critical SSIS packages for applications, related to various financial instruments.

Environment: MS SQL Server 2008/2005/2000 Enterprise, Windows Enterprise Server 2008/2003, IIS 6.0, Microsoft Visio 2003, Microsoft Reporting Services.

Projects:

Compliance & Engineering Check: This project was introduced to make sure all the Target Database server are Compliance as per SOX,HIPPA and GLBA.. This project was undertaken to automate that process and that saved us time and provided accurate results. The Project is implemented using Enterprise Policy based management, Sql Auditing Features.

Family Health Plan Ltd, India April 2011 - Nov 2014

Role: Database Administrator

Job Description:

As a Network/ Database Administrator I was responsible for maintaining Production/Test databases and the Complete LAN/WAN. Duties included troubleshooting network related issues related to Printer, Email, and Connectivity etc. sometimes training the Nave users. Also Monitoring, Scheduling of Batch Jobs and DTS packages, performing regular Backups, scheduling tasks, Creating Roles, assign required permissions to roles. Assign roles to database Users.

Responsibility:

Configuring & Implementation, Maintaining of : Win9X, Win2k Pro, Win2k Server (DNS, DHCP, Active Directories), Central Antivirus Controlling system, MS Exchange2000 Client side configuration & Server side maintenance, Citrix MetaFrameXP Ent Client side configuration. MS SQL server 2000.

Actively participated in gathering of User Requirement and System Specification.

Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2000.

Managing Database Backups and Restoration for regional databases.

Monitor the Server and fine tune to obtain optimal performance.

Designed custom Maintenance jobs – schedule to run daily and on weekends (tasks like rebuilding Indexes, defragmenting Databases, Shrink Database, and Database complete backup)

Took Initiative in designing Database Monitoring tools to track any kind of failures.

Performed DR practice tests for Data Centres outages regionally.

Developed, implemented, configured and maintained operational procedures and programs, including disaster recovery, system security.

Supported application developers and application implementation groups.

Writing Triggers and Stored procedures

Login and User Management: Adding logins, roles, groups to the MS SQL Server and maintaining proper security procedures

Taking Backups on Tape Drives using Veritas Tool

Supported application developers and application implementation groups.

Provide 24*7 ONCALL support as per the scheduled routines.

Prem Colour Industries Pvt. Ltd, India Jul 2008 - March 2011

Role: Software Engineer

Job Description:

As a Software Engineer I was responsible for developing and maintaining the company’s database. Duties included designing the customer care module and maintaining its database, troubleshooting network related issues. Performing regular Backups, scheduling tasks, Creating Roles, assign required permissions to roles. Assign roles to database Users.

Responsibility:

Configuring & Implementation, Maintaining of existing application.

Supported application developers and application implementation groups.

Developed administration web site with built in web securities, activity logs and file administrations, capable of running dynamic content on multiple web sites.

Designed DDL and DML, developed stored procedures and views for managing efficient data retrieval.

Writing SQL monitoring scripts, Triggers and Stored procedures.

Monitor the Server and fine tune to obtain optimal performance

Performed & Involved in Planning and implementing of various Backup strategies.

Taking Backups on Tape Drives.

Login and User Management: Adding logins, roles, groups to the MS SQL Server and maintaining proper security procedures

Training Users. Training nave users for Application & system usage.

Environment: MS SQL Server 2000 Enterprise, Windows Enterprise Server 2000, IIS.

Projects:

SQL Server Nightly Maintenance Check: This project was undertaken to automate the maintenance process for MS Sql server and monitor if all health checks are performed regularly or not. The Project was coded in ASP, VBScript using ADO and WMI to automate certain tasks

EDUCATION

B.Tech, JNTUH

Masters -Information assurance, Wilmington university Delaware

Contact this candidate