Sql Server Ms

Profile:

Seasoned MS SQL Administrator with over 18 years of diverse industry experience.

Well versed with MS SQL Server DBA support

Proficient in installation, configuration, troubleshooting, fine tuning and maintenance of MS SQL Server and in Business Intelligence (SSIS, SSRS and SSAS).

Design and implement database changes (Test, Development and Production)

Review and tune SQL queries, stored procedures, views, triggers

Manage health of SQL, Oracle Servers including backups, restores, monitoring

Provide support in 24x7 environments.

Estimate storage capacity. Database backup and recovery

Optimization, database tuning and performance monitoring

Design and implementation of DC-DR

Excellent interpersonal skills and communication skills.

Bachelor degree in Economics, Bachelor degree in Mathematics and Master’s degree in Computer Applications

Technical Skills:

Database Servers:

SQL Server 2016 - SQL Server 6.5, Oracle 9.x, 11g, 12c, MS-Access, ParAccel (Actian provided NoSQL based on Postgres), MySQL, AWS, RDS, Aurora.

Tools:

Crystal Reports, SSRS, SSIS, SSAS, Foglight, Diagnostic Manager (Idera), Foglight, Spotlight (Quest) for monitoring the servers, RedGate SQL tools for backup compression, Schema compare, Data Compare.

Web Servers:

IIS 6.0, MS-Proxy 2.0, Tomcat, Apache

Languages:

Java, JSP, JavaScript, C# Programming, C, Visual Basic.

Certifications:

Microsoft Certified Systems Engineer (MCSE)

Microsoft Certified Technology Specialist (MCTS)

o Microsoft SQL Server 2008, Implementation and Maintenance

Microsoft Certified Professional (MCP)

oManaging and Maintaining a Microsoft Windows Server 2003 Environment

oWorking on MCSA 2012

Professional Experience:

Contractor SQL DBA, ATCC Jan 20 – current

Supported Azure Database Servers including Availability ON group and Failover clusters. Working on Developing Monitoring on Azure systems.

Supported Dev Ops (Kanban), CI/CD, Git,

Worked on Major Data Migration for Web site (using Sitecore 9.3/6.5). Developed .Net Tool (VB .Net) for Testing.

Developing Azure Chatbot using Visual Studio C#.

Support Replication / DR. Developed PowerShell Shell Scripts for various Tasks.

Sr. SQL/Oracle DBA, Asurion Feb 13 – Jan 20

Migrated SQL/Oracle/My SQL databases to AWS EC2/RDS. Worked on Automated backup / snapshot using Python/Json/AWS CLI.

Supported Oracle Systems using RMAN, Auto failover to Data guard (using script) for Disaster Recovery purposes. Wrote Shell Scripts to automate backups and other tasks.

Upgraded from SQL 2000, 2005 to 2008 and 2012, 2014, 2016.

Built Global Availability ON group and Failover clusters with multiple nodes.

Designed and implemented database configuration to maximize system performance and availability.

Provided continuous real time performance monitoring, troubleshooting, performance tuning queries, compression, backup and cluster support.

Maintained database performance by planning and executing database tuning strategies.

Developed and maintained system documentation for all database instances and interfaces.

Worked on SSIS packages and SSRS Reports.

Created and Maintained ETL (SSIS) packages from MS Access, Sybase, and Oracle.

Upgraded Oracle Servers from 11g to 12c.

Built new Oracle 11g servers and 12c Servers.

Worked on RAC servers, OEM, Data Guard, RMAN

Sr. SQL DBA, NACCRA Nov 12 – Feb 13

Upgraded SQL Servers from 2005 to 2008.

Provided DBA Support, planned and created DR setup.

Supported Applications by database performance by planning and executing database tuning strategies.

Worked on generating Reports on SSRS.

Sr. Consultant SQL DBA, NexGen India July 08– May 12

Upgraded from SQL 2000 to 2005, 2005 to 2008.

Designed and implemented database configuration to maximize system performance and availability.

Provided continuous real time performance monitoring, troubleshooting, performance tuning queries, compression, backup and cluster support.

Maintained database performance by planning and executing database tuning strategies.

Developed and maintained system documentation for all database instances and interfaces.

Worked on moving packages from DTS to SSIS, generating Reports using Report Server.

Created and Maintained ETL (SSIS) packages from MS Access, Sybase, and Oracle.

Worked on building SSAS cubes and reports.

Senior Database Analyst, Johnson County, KS Sept 07– June 08

Installed and upgraded database (SQL 2000 to 2005/2008).

Worked as catalyst for successful development to implementation cycle of the projects.

Upgraded many high profile projects such as taxation, DMV, Waste Water.

Worked with SharePoint developers for installation and maintenance of backend database.

Worked on Business Intelligence.

Helped helpdesk system admins automate tasks using PowerShell.

DC-DR planning, log shipping, capacity planning, Hardware and licensing planning

MS SQL Server DBA, Corinthian Mortgage Corporation, KS Sept 06– Sept 07

Provided MS SQL Server DBA support, which includes installing and upgrading database software (SQL 2000 to 2005), Reporting Server, application database setup and database monitoring and tuning.

Replication of the databases across client branches.

Worked directly with executives to build reports.

SQL Server DBA, Prism Business Media, KS Apr 04 – Aug 06

Recommend, design and implement cluster (MSCS) and SQL Cluster (2000).

Played key role in set up of data center. Recommend, order and install new hardware as needed for re-design efforts. Tuned IIS Web Farm as needed.

Consolidated database servers to cut software and infrastructure costs. Consolidated Web servers (IIS, DCOM, and SMTP). Support Web Presence in 24x7 environments.

Created and Maintained DTS packages to pump data from AS400 and Oracle to SQL tables for the Web sites.

Setup and maintained SQL database for BizTalk, MOM, VOIP phone, SharePoint.

Interface with Vendor for technical support. Database design and implementation

Consultant SQL Server DBA, scheduling.com, CA Dec 99 – Apr 02

Migrated Access databases to SQL Server. Set up multiple SQL environments - Production, Testing and Development servers.

Database backup and recovery. Performance tuned the server. Wrote stored procedures, triggers.

Assisted finance department with queries, stored Procedures to recheck the billings before billing the customer. Create Reports in Crystal reports.

SQL DBA/System Admin, Tata Infotech Limited, Bombay, India Nov 98 - Nov 99

Diagnosed, monitored and resolved SQL Server performance, Database corruption issues. Replicated data on SQL Server (7.0) across the branches nationwide.

Migrated data from Sybase servers using DTS Package.

Monitoring the Servers for MRP System. Administered Scanning application and backend SQL Server. Created, Operated and administered corporate Intranet Web pages using Oracle Web Technologies (for ISP).

SQL Server DBA, Datamatics Ltd., Mumbai, India Apr 95 - Oct 98

Installation of SQL Server (6.5). Create and customize programs for accounting and Payroll in Oracle 7.3 using Forms & Reports. Maintained Oracle 7.3.

Developed and implemented workflow solutions in BeyondMail (Banyan Vines). Designed and implemented File Authorization System.

Programmer, Gujarat Machinery Manufactures Ltd., Bombay, India. Aug 93 - Mar 95

Designed, developed, implemented, maintained, and administered various systems in FoxBASE, FoxPro, Dbase, COBOL and C on a mix of networks mainly on Novell.

Education:

Bachelors of Economics (Hons.) : Delhi University

Bachelors of Mathematics : Annamalai University

Masters in Computer Applications : Annamalai University

Contact this candidate