Sql Server Manager

PROFESSIONAL SUMMARY:

* ***** ** ********** **** the 32bit, 64-bit Microsoft SQL Server in Production, Development and Testing in Clustered and Stand - alone Server Environment.

Experience installing and configuring MS SQL SERVER 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 updating with hot fix and service packs.

Experience as SQL Server DBA (2016, 2014, 2012, 2008, 2005, 2000) in Production, Development and Data Warehouse Environments (OLTP and OLAP).

Domain knowledge in multiple industries, such as Healthcare, Banking, Insurance, Manufacturing and Software. 24/7 on Call Support for Production Database.

Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/2005/2008 to 2008R2, 2012 to 2014.

Extensive hands-on experience on 2012/2014and 2016 with MS SQL Server upgrades/migrations and VMWare environments.

Extensive experience in designing the Data models for OLTP & OLAP database system.

Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, ER-Studio.

Experience in creating Constraints, Tables, Indexes, Views, Stored Procedures, Functions, Triggers and Dynamic SQL queries.

Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008, SSIS and SSRS.

Experienced in Data Extraction, Transforming and Loading (ETL) using tools such as Data Transformation Service (DTS), SSIS, SSRS, BCP, Mirroring and Replication.

Creating Conceptual/logical/physical data models using Oracle Data Modeler and Erwin.

Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.

Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2016/2012/2008/2005, SSIS, SSAS and SSRS.

Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.

Experience in Backing up, restoring the data base manually and using Tivoli Storage manager (TSM) also by scheduling the jobs and Maintenance Plans.

Extensive experience in implementing High Availability Solutions like Replication, Log shipping, Clustering and Mirroring on physical and virtual machines.

Worked on High Availability 2012 Solutions Always On.

Extensive experience in preparing Load Test plans and performance test Strategies on SQL server 2012 and 2016.

Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.

Handled multiple SQL Instances on Cluster built on SAN using RAID levels.

Explicitly used third party tools like Lite Speed, Data Mirror, Fog light and Red gate.

Auditing of database for user’s transaction, login and removing orphan users.

Actively involved in SLAs and management of Change Control Requests.

Strong experience in mentoring with team members, documentation.

Excellent Problem Solving Skills, Communication, Strong troubleshooting and Organizational skills.

TECHNICAL SKILLS:

Languages

C# ASP. NET, T-SQL, VB.NET, HTML, XML, CSS, Java Script

Operating Systems

Windows 95/2000/2003/2008/XP/VISTA/7, Sun Solaris 9, LINUX, VMware

Databases

Microsoft SQL Server 2016/2014,2012/2008R2/2008/2005/2000, Oracle 11g/12c, MYSQL, DB2

ETL & Reporting Tools

DTS, SSIS, SSRS, SSAS, Crystal Reports, VMWare tools

DB Utilities

SQL Server Management Utility, Query Analyzer

Application Software

Visual Studio 2005/2008/2015, Visual Source Safe, TFS, MS Office Suite

Tools

SQL DB Access, Performance Monitor, Backup Utility, SQL LiteSpeed, RedGate, FogLite, Erwin 9.5, Oracle Data modeler

Certification: -

Administering Microsoft SQL Server 2012/2014 Databases (70-462) - (MSCA)

PROFFESSIONAL EXPERIENCE:

Department of Conservation (State of California) August 2017 – Till Now Sacramento, California Microsoft SQL Server Engineer

Responsibilities:

Installation & configuration 2008,2008 R2, 2012, 2014 and 2016 Enterprise Editions.

Proactively responding to database alerts by installing, upgrading, migrating and configuring SQL servers to resolve issues.

Worked on SQL server 2016 Always on high availability and Disaster recovery.

Experience working with Azure SQL Database Import and Export Service.

Experienced in Data Extraction, Transforming and Loading (ETL) using tools such as Data Transformation Service (DTS), SSIS, SSRS, BCP, Mirroring and Replication.

Experience in deploying SQL Databases in AZURE SQL Server 2016.

Write T-SQL Scripts for database backup jobs and daily/weekly jobs.

Creating Conceptual/logical/physical data model level using Oracle Data Modeler.

Provided cloud computing services in IaaS and various other cloud services.

Experience in Moving Data in and out of Windows Azure SQL Databases.

Managing duties like troubleshooting, tuning input/output to enhance database performance.

Planning and gathering the requirements for setting up TFS environments for environment based migration and upgradation partitions.

Configuring SharePoint sites with Team projects in TFS and Configure TFS environment such that SQL Reporting and SharePoint interactions.

Responsible for Monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, Error logs and performance improvement in hosted databases involved Index creation\removal and scheduling jobs to rebuild/reorg indexes and update statistics.

Backing up, restoring the database manually, scheduling the jobs and Maintenance Plans.

Experience in implementing High availability like Replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.

Created views and triggers, Indexes, constraints for Database tuning and query planning.

Working with Data and other team members to provide client requirements, and suggestions to the developer team related to database activities.

Designed and implemented Backup plan and disaster recovery strategies Implemented.

Monitoring SQL server performance using SQL profiler and other performance tools to find performance.

Environment: AZURE SQL, MS SQL Server 2012/2016, T-SQL, Visual Studio 2012/2015, TFS, MS Access, BCP, SSIS, SSAS, SSRS, TFS server, Share Point, SQL Profiler.

Empower Insurance Feb 2017 – July 2017

Fort Worth, Texas

Microsoft SQL Server Database Engineer

Responsibilities:

Installation & configuration 2008,2008 R2, 2012, 2014 and 2016 Enterprise Editions.

Migrated SQL data from SQL Server 2008 to 2012 and SQL 2012 to SQL 2014 & 2016.

Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.

Experience on setup and configure 2-node SQL Cluster 2014/2016 (Active-Active).

Designed, implemented and maintained clustered and mirrored database servers.

Creating and maintaining user’s logins and Roles.

Involved in UAT and Integration testing with QA team.

Created Data collection for taking data from SSIS Packages and SSRS reports.

Knowledge on Waterfalls methodologies (Daily standup and weekly status calls).

Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Closely worked with SalesForce.com consultants while implementing the solutions.

Experienced in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2016/2012/2008/2005, SSIS, SSAS and SSRS.

Expert in T-SQL, DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

AWS Infrastructure setup Web Server, App Server and PDS Server.

Used Data Loader for insert, update, and export of data from Salesforce.com Objects.

Developed and deployed test Load scripts to do end to end performance testing.

Strong understanding of .NET Technologies for both Client Server & Web Applications.

Moved files between the File Groups and partitioned the tables to improve performance.

Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.

Experience in implementing High availability solutions like different Replication, Log shipping, Clustering and Mirroring on physical and virtual machines.

Created the Logical/Physical Data Models for the Data Warehouse using Erwin.

Used SQL Server as backend database for MS Access and MS Excel applications.

Performed Query Optimization by extensive use of Indexing and Performance Tuning.

Environment: SQL Server 2008/2008 R2/2012/2014/2016, Oracle 12c, MS-Access, Windows 2008/2012, Salesforce, T-SQL, Enterprise Manager, Query Analyzer, ASP.NET, C#, SQL Profiler, BCP, MS Excel, AWS, Erwin.

Harley Davidson Motor Company Nov 2015 – Dec 2016

Milwaukee, WI.

SQL Server DBA/Developer

Responsibilities:

Installation & configuration 2008/2008 R2/2012/2016 Enterprise & Express Editions.

Working on MS SQL Server 2016, 2012/2008R2/2008 and responsible for installation, Upgrade and configuration and provided 24 X 7 support to all production Servers.

Migrated SQL data from SQL Server 2000, 2005 and 2008 to 2012. Resolved the issues after migration of the Database.

In-place and side-by-side Migration from SQL Server 2005, 2008 and 2008R2 to 2012.

Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation).

Efficiently carried out DBA responsibilities in planning migration activities from MYSQL to SQL server and SQL to ORACLE/MY SQL in migration.

Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.

Implemented performance tuning strategies like sub query flattening, view merging and recreating indexes to speed up the performance of highly resource intensive queries.

Experience in analyzing Locks, Dead Locks and Handling the Isolation Level.

Expert in analyze execution plan and index management for better Query Optimization.

Extensive experience in implementing High Availability Solutions like Replication, Log shipping, clustering and mirroring on physical and VM’s.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Validation controls were implemented in ASP.NET for validating various entries.

Development of .NET batch applications which processes high volume of data.

Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard.

Interface with technical infrastructure on deploying patches and security upgrades.

Study and Understand the public/private cloud platforms (IaaS, PaaS & SaaS) across Amazon Web Services (AWS), Google Compute Engine, CloudStack and Rackspace.

Experience on Performance tuning and load balancing issues on SQL server 2012/2016.

Expertize in taking SQL server Backup/Restore using Tivoli storage manager (TSM).

Maintained the database consistency with DBCC commands at regular intervals.

Extensive experience in utilities and tools used for database monitoring (SQL traces, online performance monitors, reports and catalog queries).

Excellent Communication, Strong troubleshooting and Problem Solving Skills. Able to work with all type of people and Organizational skills.

Environment: SQL Server 2000/2005/2008/2008 R2, 2012, Oracle 12c, MS-Access, MYSQL, Windows 2008, T-SQL, HPQC, SSIS, ASP.NET, .NET, Query Analyzer, SQL Profiler, BCP, Performance tuning, AWS, VMware.

Regions bank

Hoover, Alabama

SQL Database Administrator Nov 2014 – Oct 2015

Responsibilities:

Planned, installed, configured and maintained the SQL Server 2008/2012 in Environment of Active/Active Cluster.

Implemented and maintained Database mirroring as a Disaster Recovery solution.

Extensively worked on migrating the databases from SQL Server 2005 to 2008 and SQL Server 2005/2008 to SQL 2008 R2.

Extensively worked on Profiler, Perfmon, DMVs, DMFs and DB and query tuning.

Migrated SQL 2008 R2/2012 databases to MySQL using the MySQL Migration Toolkit.

Developed SSIS packages, scheduled them as jobs and deployed packages in SQL Server Integration Services.

Worked extensively with Web Controls, Custom Controls and User Controls using both C#. NET and ASP .NET.

Windows Active Directory administration.

Planned and worked on Table Partition setup for rebuild and update statistics.

Extract, Transform and Load data from heterogeneous data sources to SQL Server using the SSIS Packages.

Strong Experience in working with Database Programming, Object Oriented Analysis and Design, Documentation under UML and Package and Deployment using .NET Setup and Deployment.

Plan, analyze and develop Ad-hoc Reports using the SSRS and Report Manager to support various user requirements.

Involved in physical storage configuration of SAN with different RAID levels.

Worked with TDP and TSM tool for backup and recovery and written SSIS packages for the backup and restores for few applications

Developed and optimized database structures, stored procedures, DMVs, DDL triggers and user-defined functions.

Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.

Environment: MS SQL Server 2008R2/2008/05/00, Windows 2008 Server, MYSQL, Linux, SSRS, SSAS, SSIS, Microsoft Visual Studio, DB2, MSBI, VMware, C#. NET and ASP .NET.

Oraconnect Technologies Jan 2012 – June 2014

Hyderabad, India.

System Engineer

Responsibilities:

Plan, implement, install, operate and maintain systems hardware, software applications and Information Technology infrastructure.

Provide hardware and software engineering support for Information Systems utilizing object oriented programming and client / server applications.

Assistance provide with systems planning, business information analysis and process improvement initiatives.

Working as an MS SQL Server 2012, 2008R2/2008 Administrator and responsible for installation, configuration, tuning and support provided to all production systems.

Database Migrate from SQL 2000, 2005 and 2008 to 2012. Resolved the issues after migration of the Database.

Involved in the resolution of system, hardware, software and infrastructure problems.

Define reporting requirements and gather data, using MS Access, and MS PowerPoint to create and maintain management reports, also export data from MS access to MS Excel to create Pivot table for management do more analysis.

Used MS Access/VBA to send system generated e-mails, verify passwords using Spellchecker, manage and report embedded Word and Excel documents.

Understanding the customer requirements.

Support staff and end user with resolution of systems issues, malfunctions or software programming problems.

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

Manage full software development planning process including the design of specifications, diagrams, techniques and strategies.

Environment: Microsoft SQL Server 2008/2012 Enterprise Edition, Systems security, Management Studio, Query Analyzer and Quality testing

HDFC Bank Ltd, May 2010 - Dec 2011

Chennai, India

Jr. SQL Database DBA/Developer

Description: The Housing Development Finance Corporation Limited (HDFC) was amongst the first to receive an in-principle approval from the Reserve Bank of India (RBI) to set up a bank in the private sector. The project decaled with database management such as security, performance tuning, writing queries, triggers.

Responsibilities:

Installed and configured SQL Server 2000 and 2005 on Windows 2003.

Worked on Client/Server tools and Query Analyzer to administrate the SQL server.

Created and managed schema objects such as Tables, Views, Indexes, Procedures, Triggers and maintaining referential integrity.

Taking Database Full Backup, Transaction log backup & differential backup as per backup strategy daily Routine.

Used Windows Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of users, applications.

Involved with MS SQL Server Log Shipping and Configured SQL Mail.

Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.

Developed database objects like tables, views, stored procedures, indexes etc.

Rebuilding the indexes at regular intervals better performance.

Worked with DTS packages to load the massaged data into Data warehousing system.

Maintaining the Database consistency using DBCC commands at regular intervals.

Environment: Microsoft SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, SQL Management Studio, Query Analyzer, SQL SERVER 2000/2005 DTS packages and T-SQL.

Contact this candidate