Email: ac8q1i@r.postjobfree.com Contact : 302-***-****

Professional Summary:

10+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2016, 2012, SQL Server 2008 R2, 2008 and 2005

7 years experienced in Microsoft’s Enterprise Commerce Volume Licensing Applications.

4 years of MSBI experience in troubleshooting SSIS Packages and SSRS reports of different versions (SQL Server 2012/2008 R2)

Expertise in SQL development activities like writing queries, creating packages and reports etc.

Extensively worked on SQL and IIS application Support in QA, UAT and Production environments.

Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

Experience in Disaster Recovery Planning and Security Management operations.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.

Configured High Availability solutions like Always On, Database Mirroring, Log shipping and clustering.

Experienced in different types of Replication Models like Snapshot, Merge and Transactional.

Expertise in Performance Tuning and Query Optimization using native tools like Database Engine Tuning Advisor, Query analyzer.

Experienced in troubleshooting performance issues using Database Management Views (DMV’s), extended events, SQL Profiler, PerfMon and 3rdparty tools like AppInsight, Performance dashboard.

Excellent Developer skills in developing Stored Procedures, Indexed Views, User Defined Functions, Triggers.

Expertise in SQL Azure Admin. Migrated SQL DBs from on-prem to Windows/SQL Azure environment.

Proficient in dealing with Windows Azure - Compute, Networking, Storage, Security, Identity, Developer Services, Monitoring and Management.

Expertise in Virtual Networks, Virtual Machines, Cloud Services, Express Route, Traffic Manager, VPN, Load Balancing, Auto Scaling.

Experienced in developing tools & automation for reducing manual efforts, pro-active monitoring using scripting technologies as per identified requirements

Experienced in Installation, Patching, Configuration and Administration of SQL Server 2016,2012, 2008 R2 and 2005 and VM Guests.

Experienced in Datacenter Migration; Experienced in managing SQL Shared Instances.

Designed and implemented enterprise wide Backup\Recovery strategies over Data Domain Appliance.

24X7 on call support for Production databases, Troubleshooting and problem Solving.

Experienced in managing resources by assigning various projects and have successful track record of completing 95% of the projects on time. Experienced towards ITIL life cycle process.

Good interpersonal Skills, Result Oriented, hardworking with quest and zeal to learn new technologies.

Strong multi-tasking aptitude to manage multiple issues/projects in a fast-paced environment

Excellent communicator with perseverance, creativity and reasoning ability to analyze complex cases and effectively handle emerging process problems, experienced in managing Onsite and Offshore resources

Commendable leadership skills coupled with effective interpersonal techniques that facilitate interaction with people of diverse cultural background across the organizational ladder and manage change with ease.

Versatile and multi-skilled with ability to manage multiple responsibilities simultaneously; achieve defined goals, objectives and milestones

Proficiency in Service Management Framework - Incident, Change, Release, Problem Managements. SLA maintenance, Key Performance Area measurements.

Technical Skills:

Languages

T-SQL

RDBMS

SQL Server 2016/2014/2012/2008R2/2005/2000

Web Technologies

Internet information services, Azure IAAS, PAAS

Operating Systems

Windows Server 2016/2012/2008/2003/2000, Windows 10/7/Vista/XP.

SQL Server Tools

SQL Profiler, Import\Export Wizard, SQL Server Performance Dashboard

Monitoring Tools

AppInsight, Kusto, SCOM, Fidler

Development Tools

Power shell Scripting

High Availability

Always On, Log Shipping, Replication, DB Mirroring and Clustering

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Certifications:

Microsoft Certification Professional ID: 3054487

Microsoft® Certified Solutions Expert Cloud Platform and infrastructure - Sep 2016

Microsoft® Certified Solutions Expert Private Cloud - Jan 2016

Microsoft® Certified Solutions Associate Windows Server 2012 - Dec 2015

Microsoft® Certified Solutions Associate Windows SQL Server 2012 /14 - Dec 2015

ITIL Foundation certificate in ITSM from EXIN Version 3.0 - Sep 2014

Educational Qualifications:

Degree

University / Board

Year of Passing

M.C.A

I.A.S.E Deemed University, Rajasthan, India

(04/2012)

B.Sc. [M.E.Cs]

Kakatiya University, Hanmakonda, Warangal, India

(05/2002)

Professioanl Experience:

Client: State of Delware, New Castle, DE

Title: Sr. SQL DBA

Duration: Oct 2017 – tilldate

Child support is the money a parent pays to help meet his/her child’s need when child is not living with parent. It is also called IVD program. Child support program was established in 1975 as Title IVD of Social Security Act. Services provided by Child Support Program are Locating parents, Establishing Paternity, Establishing Court Order, Enforcing Court Order, Collecting and processing Child Support payments.

Responsibilities:

Test programs or databases, correct errors and make necessary modifications.

Handling Team Foundation Server administration activities which consists of SQL Database

Supporting the SQL batch processing performed at the Database level.

Modify existing databases and database management systems or direct programmers and analysts to make changes.

Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.

Work as part of a Dev team to coordinate database development and determine project scope and limitations.

Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.

Train users and answer questions, Manage users and user access levels for each segment of database.

Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.

Review project requests describing database user needs to estimate time and cost required to accomplish project.

Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.

Providing production support – data administration activities for production servers, monitoring day-today processes, timely fix of the production problems encountered, data fixes and troubleshoot the issues for the business users and business analyst.

Discuss business solutions with State Business Analysts, resolve existing problems and improve the application stability.

Coordinate with business clients, support the application and implement the process as per specifications provided.

Requirements gathering and analysis, time estimates, preparing design documentation, design reviews, development, testing and deployment of application enhancements, project planning.

Answering the technical queries, driving the product initiatives and metric collection and analysis.

Reviewing of work products and deploying the application in the test environment and initiate the process of user acceptance testing. It includes fixing of bugs and fixing technical errors that may come up during this phase.

Supporting the system components during system testing, integration testing and during promotion of these components to production environment.

Regular interaction with the Conduent Manager, Database administrators, Network and System Administrators, Application Users – all belonging to different departments and divisions of Delaware State to ensure the smooth running of the applications.

Provide in-depth technical incident investigation, diagnosis, and resolution expertise resolves.

Detection of possible problems Database administration of complex issues

SQL Database performance debugging and tuning

Rebuilding the indexes at regular intervals for better performance.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Monitored and modified Performance using execution plans and Index tuning.

Environment: MS SQL Server 2016, SSIS, SSRS, Windows server 2016, $ Universe Batch scheduler. MS TFS 2017, MS Access

Client: Microsoft, Redmond, WA

Title: Sr. SQL DBA

Duration: Apr 2016 – Sep 2017

EC MS License & MOET, POET are the core systems which serves as a repository for volume licensing customer agreements, contacts, purchase orders, sales transactions, and marketing program rules. In addition to financial and management reporting, MS License provides revenue source data to many other downstream applications, including MS Sales where revenue recognition rules and deferral calculations are applied, and SAP, the primary system for revenue processing.

Responsibilities:

Bringing up efficiency/value add by implementing service improvements, excelling operations and creating efficiency with technical solutions.

Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.

Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.

Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.

Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning.

Setup High-Availability as part Disaster Recovery Strategy for the Databases

Build & Migration of existing systems to Cloud (Windows Azure) as per business need & technology upgradation without interrupting service availability

Reporting project status service availability, infrastructure availability, major incidents, ticketing trend, new projects & customer experience weekly, Monthly & Quarterly to all stake holders

Validate service performance across work streams and publish Service Dashboard on a periodic basis indicating project health with tracker and measure/report performance

Major Incidents, Crisis handling and drive till resolution with problem management analysis for a permanent solution to improve customer service & support

Collaborating with Engineering\Release management team to develop process changes in response to identified issues in the production environment & business need

Review status with the Project teams and SMEs in constantly exploring further process improvements, automation and cost optimization for the customer

Create Linked Servers to SQL Servers and other databases

Design database Backup and Restoration Strategy

Designed and implemented comprehensive Backup plan using SQL LiteSpeed.

Resolved and tweaked memory pressures caused during product release.

Worked with customers on Application rollouts and server migrations.

Troubleshoot performance problems and fine-tuning of databases.

Environment: MS SQL Server 2012, SSIS, Azure IAAS, PASS, Windows server 2012.

Client: Microsoft India

Title: SQL DBA

Duration: Jan 2011 - Mar 2016

Enterprise Commerce IT Project team will make sure to process the Purchase orders, Benefits, Agreements, Quotations, Reporting of the Microsoft Licensing

Responsibilities:

Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Involved in Source Data Analysis, analysis and designing mappings for data extraction responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

Expert in implementing the snapshot isolation and DDL triggers.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

Performed installation of SQL Enterprise 2012 SP1 CU 5 64-bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Designed and created databases, tables, views, store procedures and triggers.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Used Stored Procedures, DTS packages, BCP for updating Servers.

Automated messaging services on server failures, for task completion and success.

Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis

Environment: MS SQL Server 2012, SSIS, Azure, Windows server 2012, SFTP, Microsoft Reporting Services.

Client: Microsoft India

Title: SQL DBA

Duration: Mar 2008 - Dec 2010

Microsoft Project Product Development Services our mission is to provide the applications and services necessary for the Product Groups to develop great Microsoft products. Our objectives are to safeguard the business of our customers, help deliver global operational and infrastructure efficiencies, and ensure that the applications we support meet or exceed corporate governance standards for Security and Privacy.

Responsibilities:

Perform business analysis, technical analysis, systems design, application software programming.

Prepared DFD's & Entity Relationship(ER) diagrams.

Restructuring the stored procedure, designing, coding and developing the same using the T_SQL Programming .

Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.

Extensively worked on Dynamic Management Views in SQL Server 2005.

Installed, authored, and managed reports using SQL Server 2005 Reporting Services.

Managed the migration of SQL Server 2000 databases to SQL Server 2005.

Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

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.

Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.

Prepared the project management and technical documentation.

Unit Testing the SSIS packages with respect to its flow and performance issues.

Solving the Bugs Reflected by the Testing team.

Rebuilding the indexes at regular intervals for better performance.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Extensively worked on DBCC commands and Dynamic Management Objects.

Expertise in SQL Server Reporting Services and SQL Server Analysis Services.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Complete documentation about the database. Recovering the databases from backup in disasters.

Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

To analyze long running slow queries and tune the same to optimize application and system performance.

To set up SQL Server configuration settings for better server management.

Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: MS SQL Server 2008 R2, Windows server 2008, MS TFS, MS Access

Client: HSBC IT

Title: SQL Server Administrator

Duration: Sep 2005 - Feb 2008

HSBC IT will take care of the Application issues and system related issues while processing the HSBC Bank Global customer calling the call center in Hyderabad.

Responsibilities:

Database Administrator, Database Programming.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Rebuilding the indexes at regular intervals for better performance

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Deploying new code base release to UAT and Production Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Working with customers on Application rollouts and server migrations.

Extensively worked on Enterprise Manager for managing the database.

Troubleshoot performance problems and fine-tuning of databases.

Involved in Index Analysis and Performance Tuning.

Worked with different upstream team for downloading ETL MART data.

Converting DTS packages into SQL Server 2005 Integration Services.

Migrating SQL Server 2000 data bases into SQL Server 2005.

Recovering the databases from backup in disasters.

To analyze long running slow queries and tune the same to optimize application and system performance

Environment: MS SQL Server 2005/2008, windows Server 2008, Lotus Domino server, Windows XP, 2000, NT

Contact this candidate