SUMMARY

• 8 plus Years of Experience in SQL SERVER database administrationand development for very large and complex databases in SQL server 2016, 2014, 2012, 2008, 2005 and 2000.
• Extensive experience in Installation, Configuration and Administration of SQL server in a Clustered and Stand - Alone environment.
• Experience in In-Place and Side-by-Side migration of MS SQL server 2000/ /2008r2 and 2008r2 to 2012/2014/2016.
• In-depth noledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC, Re-indexing, Updating Statistics and online indexing. Expertise in SQL server Backup/Restore, having noledge in upgrading of SQL servers.
• Have extensive experience in DBCC and DMV's to check teh health of teh server.
• Solid experience and outstanding noledge on High availability & Disaster recovery techniques like Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
• Implemented Always-on Availability Groups.
• Experienced in Administering, configuring and managing SAN, EMC storage for backups and disaster recoveries.
• Experience in creating and implementing maintenance plan with stored procedures, T-SQL Scripts to ensure smooth running of SQL server.
• Experience in automation of administrative tasks like creating Jobs, Alerts using SQL server Agent.
• Expert in using Third party tools like Lite Speed, Red Gate to speed up backup operations.
• Extensive experience in configuringRegistered Servers, Linked Servers,andMulti ServerAdministration.
• Auditing of database for users transaction, logins, Database action and fixing orphan users.
• Experience in configuring DB Mail and Migration of Data from Excel, Flat file, Oracle to MS SQL server by using SSIS, BCP and DTS utility.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for rectifying teh errors.
• Experience in creating SQL Server Reports usingSSRS 2005 and 2008.
• Strong interpersonal skills, with teh ability to easily and effectively interact with technical, non-technical, and business staff at all levels.
• Experience working with change control process/change management which involves development, testing and production.
• Thorough noledge on SAN environments, RAID levels, VMware Environments.
• Acquainted with all teh phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation and Agile methodologies including SCRUM and Sprints.
• Experience in configuring, deployment and support of cloudservices including Amazon Web Services.
• Experience in Oracle 11g/10g/9i Databases installation and configuration.
• Strong experience in mentoring junior team members, documentation.
• Extensively worked in 24x7 Productionenvironment.

TECHNICAL SKILLS

Databases: MSSQL Server 2016, 2014, 2012, 2008, MS SQL Server 2005,2000

Programming: C, C++, T-SQL, POWERSHELL, Html.

Operating System: Windows 2008/2003 & Windows 10, Unix, Linux.

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

Third party tools: Litespeed, Idera, SQL Compare, Redgate, Net backup and SQL Sentry.

ETL Tools: jheData transformation services(DTS), SQL Server Integration services(SSIS).

PROFESSIONAL EXPERIENCE

Confidential, DULUTH, GA

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL server 2014, 2012 and applying service packs in both Cluster and stand-alone environments.
• Migrated SQL server from 2008R2 to SQL server 2012/2014 databases.
• Tuned queries which are running slow using different ways such as evaluating joins, indexes, updating Statistics and code modifications.
• Involved in daily routine activities like backup, restore, refreshing databases as per requirements.
• Configured log shipping with monitoring instance as a disaster recovery solution.
• Implemented Always-on-Availability Group as part of High Availability solution on SQL server 2014 and 2012.
• Created database mail and operators.
• Involved in index maintenance plans like rebuild & reorganizing teh indexes according to index fragmentation.
• Implementation of SQL server logins, Roles and Autantication modes as a part ofsecurity policies.
• Created jobs and alerts using SQL server agent, monitoring and troubleshooting teh jobs.
• CreatedLinked Servers between 2005 and 2008 R2 servers.
• Installed and administered multiple VLDB Oracle 10g and 11g databases.
• Provided RAID level suggestion for data files, log files and tempdb drives.
• Implemented data partitioning for large tables to increase teh performance.
• Configured Replication (transactional replication).
• Resolved blocking, deadlocks, client/server connectivity, database consistency checks using DBCC utilities.
• For performance analysis used teh tools like SQL server profiler, Index Tuning Wizard and database Tuning Advisor.
• Developed SSIS packages to transfer teh data between production and development environments.
• Developed SSRS reports on DBA metrics data.
• Developed web applications and help refractor legacy applications.
• Involved in ETL architecture enhancements and extensively performed full lifecycle ETL software development - analyze, design, develop, document and test using SSIS.
• As a DBA predicted how test applications will perform once they are moved to production.
• Performed New development and maintenance work can be in teh test environment and operational applications in teh production environment.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema.
• Using AWS DMS migrated ORACLE databases to SQL databeses.
• Installation, creation and configuration of Oracle Database software (Database, Patch, Client) on Windows and Linux Platforms.
• Worked on Oracle Replication using Quest Shareplex, Oracle10g Dataguard configuration and administration.
• Designed and developed a backend for client’s website using C#, .NET and SQL Server.
• 24X7 on call support.

ENVIRONMENT: Microsoft SQL Server 2000, 2005, 2008 R2, 2012 and 2014, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL.

Confidential, WI

SQL Server DBA

Responsibilities:

• Experience with Multi- Servers and Multi-Terabyte Databases design for Very Large Databases.
• Performed installationsas per client requirements.
• Oracle11g/10g/9i Databases installation and configuration.
• Performed migration from SQL server2008 to SQL server2012.
• SQL Server 2012 Always-On experience with high availability.
• Developing T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
• Automated regular Database Maintenance tasks by creating Jobs and Alerts using teh SQL server agent and Database mail.
• Performed backup using backup compression and data compression.
• Troubleshoot for SQL Server performance related Issues in teh servers using DBCC commands, DMVs and Performance Counters.
• Configured and managed database maintenance plans for update statistics, database integrity check and backup operations.
• Configured Database Mirroring with high performance and high safety mode.
• Implemented Snapshot and Transactional Replications.
• Migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, Attach/Detach and Data Migration tools.
• On teh new SQL Servers configured required users and fixed orphan users with rev login script.
• Extensively worked on Transparent Data Encryption (TDE).
• Implementation of SQLLogins, Roles and Autantication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
• Truncated/shrink transaction logs, checked data allocation errors and any data inconsistencies and updating database statistics.
• Responsible for setting up Team foundation server, creating projects and adding members. Configured and deployed infrastructure.
• Responsible for managing share point sites.
• Responsible for managing, compiling and deploying code on TFS.
• Rendered reports in CSV, PDF, XML and Delivered reports by file share and E-mail according to schedule.
• Utilized SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases.
• Installed, Configured SSRS and Created, Deployed SSRS Packages.
• Provide Operational Support to modify existing Tabular SSASmodels to satisfy new business requirements.
• Troubleshot performance issue as and when they arose using ticketing system using BMC Remedy application for creating and tracking ticket and on floor Tech Support team for resolution.
• Develop documentation dat sufficiently describes technical deliverable as required for internal controls so dat teh maintenance responsibility can be passed on to production support team.

ENVIRONMENT: SQL Server 2012, 2008 R2/2005/2000, Windows 2003/ 2008 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008.

Confidential, MAYFIELD, OHIO

SQL SERVER DBA

Responsibilities:

• Finding out any missing standards and Providing Best practices for maintaining SQLServers efficiently. Successfully implemented several new standards for teh Client, with tremendous proven improvement as part of SQL Security Vulnerability Remediation.
• ProvidedDBA support for multiple applications in development, test, and production environments.
• Performed installation of SQLEnterprise bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise data centres. Patch applications.
• Developed strategies in migration of SQL server from one version to another.
• Designed and created database objects like tables, stored procedures, views, triggers, user defined data types and functions.
• Implementedsecurity and object permissions such as maintain database autantication modes, creation of users, configuring permissions and assigning roles to users.
• Managed database backup and disaster recovery including Point-in-Time recovery.
• Configured database mirroring as part of disaster recovery solution, clustering as high availability solution and replication to achieve scalability of databases and to improve read performance.
• Created and scheduled SQL serverautomated jobs in a timely manner of daily, weekly and monthly processes.
• Monitored SQL server error logs, job history logs, space usage, customer complaints, tickets, optimizing queries, tracing long running queries and deadlocks.
• Implemented performance monitoring and database tuning using different tools such as SQLProfiler, Database Tuning Advisor.
• Created, modified, monitored, rebuild and reorganized Indexes, Constraints, Views etc.
• Used Performance counters to find teh bottlenecks of servers in CPU, Disk I/O and memory devices to improve teh server as well as database performance.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, excel files and loading into SQL server.

ENVIRONMENT: SQL Server 2000/2005/2008 R2, T-SQL, Excel, Windows 2003/2008 Server, Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, Reporting Service(SSRS).

Confidential

SQL Server DBA/DEVELOPER

Responsibilities:

• Maintaining SQL Server 2005/2008 R2 servers for day-to-day activities.
• Regular SQL Server Maintenance Activities dat include Index rebuilds and updates statistics, Database Backup, Data Imports and Exports.
• Maintained security related activities such as logins and database object permissions.
• Managing Login Autantication and User Privileges for more TEMPthan 100 users.
• Resolving security issues by creating new roles and granting required permissions to teh users at various levels.
• Used log shipping for synchronization of database.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables, added columns, triggers and worked on index tuning and stored procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Automated and monitored daily administrative tasks including space management, object alteration, database backup and recovery, database status, logs, space utilization, extents, checkpoints, locks and long transactions.
• Part of a team for analyzing and implementing teh physical design for database.
• Writing complex Stored Procedures to meet teh business requirements.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

ENVIRONMENT: MS SQL Server 2000/2005/2008 R2, Windows 2000/2003/2008 Servers, MS Access, Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, Reporting Service(SSRS).

Confidential

SQL Server DBA/DEVELOPER

Responsibilities:

• Responsible for installation, configuration and complete administration of different versions of SQL server.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Implementation of robust backup and recovery strategies.
• Apply best practices to teh SQL serverinfrastructure.
• Perform database refresh from higher to lower environments.
• Performance tuning using IDERA, Profiler, SCOM, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers.
• Monthly auditing of teh serversfor security, performance and best practices.
• Develop and deploy server reports using SSDT for managerial decisions.

ENVIRONMENT: MS SQL server 2000, 2005, T-SQL, Windows NT/2000/2003.