Sql Server Manager

Objective

Seeking a full-time position as a SQL Dba that enables me to utilize my strong technical skills, experience and educational background.

Summary:

Over 2+ years of IT experience as SQL Server DBA/Developer ( 2014, 2012, 2008, 2005, ) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP)

Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).

Solid experience in database design and creation of schemas, writing stored procedures, functions, triggers, DDL and DML SQL queries.

Experience in Extraction, Transformation and Loading of data from heterogeneous sources like Oracle 10g/11g, Flat files, XML, CSV files and Microsoft SQL Server.

Strong knowledge with development in Agile methodology and Multi-tier applications.

Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping.

Knowledge on programming languages like C and C+

Managed Security like windows and SQL Logins, Roles, permissions for various users.

Experience with SQL 2012 ALWAYS ON and Data Migration from MS SQL server 2000 to 2005, 2005 to 2008, and 2008 to 2012.

Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies.

Created Database Snapshots on Mirror databases for generating the reports for business crew members and worked with linked servers.

Created Database maintenance plans for compressed full DB backup and transaction log backup, Check Database Integrity, Index maintenance and update statistics.

Trouble-shooted Application and Backup jobs failed issues and SQL cluster installation and cluster resources failed issues.

Configured, monitored Transactional Replication for different clients for reporting purpose.

Configured tempDB w.r.t to the no of processors and resolved Application connectivity issues like connection timeouts, connection pooling and Blocking, Dead lock issues.

Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services).

Experience in migration from Oracle to SQL Server using SQL Server Migration Assistant.

Involved in migration of DTS Packages (2000) to SSIS and troubleshoot migration issues.

Prioritized open requests and responded to the customer with an estimated completion date. Implemented security policies as they relate to the Oracle databases.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Experience in server virtualization using VMware & Hyper-V.

Good knowledge of System Development Life Cycle (SDLC).

Experience in creating and managing Reporting services using SSRS and Tableau.

Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.

Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.

Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and also analyzing the execution plan and index management for better Query Optimization

Education

Masters in Management Information Systems, South University, Tampa, FL, USA.

Bachelors in Hindustan University, Chennai, India.

Technical Skills

SQL Server Tools

: SQL Server Management Studio, Configuration Manager, Performance Tools & SQL Profiler, Data Tuning Advisor.

Languages

: T-SQL, My SQL, HTML, XML, C, C# ASP. NET

Operating Systems

: Windows 95/2000/2003/2008/XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases

: MS-SQL Server 2014/2012/2008/2005, Oracle 9i/8i, 10g, 11g, MySQL, MS Access

ETL Tools

: Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Reporting Tools

: SQL server reporting services (SSRS), Tableau, Informatica

Professional Experience:

SQL Server DBA – Pureminds IT Services ltd. Atlanta, GA. [Jan 2017- May 2017]

SQL, SSMS, BI-SSIS, SSRS, Tableau.

Managed and Administrated the SQL Server 2012/2014/2016 production servers.

Developed strategies, roadmaps and designs for large-scale organizations.

Managed to bridge connection and run SQL queries between SQL server and Hadoop Data stores using Polybase technology in SQL server 2016.

Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.

Performed daily tasks including backup and restore by using SQL Server 2014 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Performed Always ON and Disaster Recovery techniques in SQL server 2014.

Oracle Database 12c with Oracle Advanced Security, Database Vault, Audit Vault, Key Vault and Database Firewall.

Experience of migrating data from RDBMS to RedShift and process around data modeling.

Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.

Using SSIS, migrated data from Oracle Server Database to SQL Server Database.

Extensively worked on performance issues like update statistics, Auto Stats.

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

Created various jobs to check health of the server and to troubleshoot.

Published of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

Created Availability groups in Always ON for 2012 SQL server, restored databases in Always ON environment, where we have 2 secondary replicas.

Developed and deployed SSIS packages, stored procedures, functions, and triggers.

Managed monthly checkups for our DR servers, manual failover to different nodes for regular checkup by using SELF HELP 2.0.

Created SSIS packages in SQL Server 2012 for sources database for Tableau dashboards.

Managed Eagle databases and supported to eagle applications.

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Conducting user trainings on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.

Rotational Bi-weekly 24/7 on call support.

SQL Server DBA – Digieon Technologies Pvt Limited Banglore, India [Jan 2015- Oct 2015]

SQL, SSMS, BI-SSIS, SSRS

Responsible for supporting over 350 SQL instances which include SQL 2008 / R2 /12 and 2014

Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.

Configured\Monitored\Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery. Support and troubleshooting for Transactional replication.

Installation of SSIS 2008R2 Active/Passive cluster on a Windows 2008R2 cluster and Performed in place upgrade of SSRS from 2008 to 2008R2.

Installed SQL Server 2012 Cluster and configured ‘Always On’ availability group set up on Windows Server 2012 in Development & SIT environments.

Maintained data integrity and database structure including tables, views and triggers.

Creating databases and logins and users with permissions in SQL server 2005/2008.

Modeling all databases (Sybase, Teradata and Oracle) for client.

Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business Requirement Document).

Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.

Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.

Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.

Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.

Backup and Recovery of Production Databases and Tuning them for better Performance.

Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics

Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.

Deploying and Troubleshooting SSIS packages with a multitude of Data sources and complex data conversion logics.

Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.

Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.

Creating new Databases and Migrated SQL Server 2005 databases to SQL server 2008R2 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.

Created Linked servers accordingly in between the different servers based on the requirement.

Worked on Migrating Oracle & MYSQL databases to MSSQL using SSMA tool.

Transformed data from various data sources using OLE DB connection by creating various SSIS packages.

Implemented Pager options to inform corresponding DBA basis on each Job Status.

Used Quest Lite speed to set up Log Shipping and create Backup Job’s.

Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).

Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.

Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.

Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Foglight Performance Analysis and Spotlight.

Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.

Performed Backup and recovery & Automation of Backups using maintenance plans.

Deployed SSRS reports and granted appropriate roles and permissions.

Jr. SQL DBA/Developer – Digieon Technologies Pvt Limited. Banglore, India

[Jan 2014- Dec 2014] MS SQL, MSBI – SSIS, SSAS, SSRS

Worked with commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in a set of logic (SQL Server 2008).

Configured and managed virtual Servers and worked on virtualization and clustering environment.

Created Power shell script to run update statistics on objects parallel on large databases to minimize the run time.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.

Worked on generating MOM and SCOM reports on mission critical servers for CPU usage, Memory (available memory) and disk space.

Performed horizontal data partitioning for efficient management of database tables and indexes, Full text indexes, Using Contains, Tuning LOB, BLOB data types.

Used Quest Foglight, Quest Spotlight and Confio Ignite tools to monitor SQL Server Performance and to generate Performance reports.

Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.

Worked in Active/Active Cluster environment as a High availability solution.

Performing Backup/Restore to/from Legato server (Tape) and Disk.

Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.

Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

Expert in Performance Tuning of the Stored Procedures.

Implementation and management of operating systems (Windows), and virtualization (VMware/Hyper-V)

Monitored and modified Performance using execution plans and Index tuning.

Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

Checking Database Health by using DBCC Commands and DMVS.

Used log shipping for synchronization of databases.

Prepared Documentation for the Disaster Recovery plan

Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.

Incremental loading of dimensions, facts, error handling in SSIS.

Created Dynamic SSIS packages, to load Stage tables from text files.

Designed Data Integrator jobs with Error Handling and email notifications.

Worked on SQL Server Reporting Services (SSRS), drill down, parameterized reports, and cascading reports deployed them on Report server from Report Manager.

Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and

handling maintenance Jobs.

Used ERWIN for Entity Relationship modelling.

Managing Databases spread across multiple servers in Production, Development, staging & testing environments.

Responsible routine DBA jobs like Backups and Restores.

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Database DBA/Developer – South University Tampa [Oct2016-Dec2016]

Student Database Tools: Edera, SQL Server Management studio.

Facilitating and providing International student Database to the faculty starting from scratch, develop it and maintain. Using Edera(Third party) trouble shooted performance issues in student database

Academic Projects:

Developed and performed deliverables in different phases of a project life cycle in Axosoft (project management tool).

Developed a Movie Ticket reservation system multi-dimensional model using SQL, developed ETL using INFORMATICA 9.5.1. Created diagrams for efficient VMware or Hyper-V deployment planning using Microsoft Visio.

Contact this candidate