Post Job Free

Resume

Sign in

Sql Server Data

Location:
Alpharetta, GA
Posted:
August 05, 2019

Contact this candidate

Resume:

Rakesh Kumar Daram Phone: 409-***-****

Sr. SQL Server Database Administrator Email: ac9zv0@r.postjobfree.com

SUMMARY

9+ years of Microsoft SQL SERVER Database Administration and Development in Production, Development and Testing environments on Clustered and Stand-alone Servers.

Strong understanding of RDBMS concepts as well as Data Modeling Concepts.

Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.

Strong experience in developing T-SQL Queries (DDL, DML, DCL), Views and Stored Procedures

Experience installing attended and unattended mode MS SQL SERVER 2005, 2008/R2, 2012, 2014 & 2016; updating with hot fix and service packs.

Extensive experience in implementing Always-On HADR technique in same subnet and multi subnet clusters.

Extensive experience in implementing different High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.

Extensively worked on Active-Active and Active-Passive Clustering and multi node clustering.

Experience working on Hyper-V and VMWare virtual environments.

Thorough Understanding of different RAID levels implementation.

Experience In in-place and Side by Side upgrade of MS SQL SERVER 2000/2005/2008R2/2012/2014 to newer versions.

Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.

Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc. depends on scenarios.

Experience in implementing Policy Based Management, Resource Governor, Data Collector sets and Backup Compression Techniques.

Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Trouble shooting, Backup and Restore Procedures.

Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.

Experience with Microsoft SQL Server Integration Services and SQL Server Reporting Services using Business Intelligence Development Studio (BIDS)

Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.

Experience in Migrating DTS 2000 packages to SSIS packages using Migration Wizard.

Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Strong ability in Scheduling and deploying reports on Report manger.

Experience working on Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).

Experience in using the DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.

Expert in Data Integrity, Performance Tuning, Query Optimization, Database health Check, Indexing, statistics.

Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.

Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.

Experience in setting up CMS (Central Management Server).

Experience in setting up and Implementing SCCM 2012 (Microsoft System Center Configuration Manager).

Experience in using dynamic management Views (DMV) and functions (DMF) Of Tables, Triggers, Store Procedures for performance monitoring and tuning.

Experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.

Experience troubleshooting Deadlock issues using trace flags and Extended Events.

Experience using BCP, BULK INSERT, Import/Export data from different Data Sources.

Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.

Experience supporting very large databases (VLDB) and Complex Databases.

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

Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer, Extended Events for performance analysis.

Experience in Backups, Restores and Maintenance Plans.

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

Configured SMTP Server for Database Mail setup and set up Alerts for the Threshold values.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Hands on experience with third party tools like Lite Speed, Fog light, Red gate, Idera, CommVault, SCOM & SolarWinds.

Auditing of database for users transaction, login and database action and removing orphan users

Experience working with a team of business analysts, data architects, application developers, ETL developers and testers.

Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Expert in using Version Control Software like Visual SourceSafe (VSS) and SVN.

Experience working in change control process environments.

Flexible, Enthusiastic and project-oriented team player with good communication and analytical skills to develop creative solution for challenging client needs.

Strong experience in mentoring team members, documentation and 24/7 on call production support.

technical skills

Languages

T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, PowerShell

Operating Systems

Windows 2000/2003/2008/2012/2016, UNIX (Sun Solar), LINUX

Databases

MS-SQL Server 6.5/7.0/2000/2005/2008/2012/2014/2016, MS Access

Reporting Tools

SSIS, SSRS, SSAS

DB Utilities

SQL Server Management Utility, Query Analyzer, BIDS, Visio,

Third party Tools

Erwin, Visio, Red gate, Lite Speed, CommVault, ServiceNow, Idera, SVN, TFS, SCOM, Active Batch, SCCM 2012/R2, SolarWinds.

PROFESSIONAL EXPERIENCE

Georgia Dept. of Transportation, Atlanta GA Nov 2016 -Till Date

Sr. SQL Server DBA

Description: The Georgia Department of Transportation is the organization in charge of developing and maintaining all state and federal roadways in the U.S. state of Georgia. In addition to highways, the department also has a limited role in developing public transportation and general aviation programs.

Environment:

Microsoft Windows 2008R2/2012/2016 Server, Microsoft SQL Server 2005/2008 (R2)/2012/2014/2016, CommVault, ActiveBatch V9/V11, SCCM 2012, TFS, SharePoint 2010/2013/2016.

Responsibilities:

●Support SQL Server 2005/2008(R2)/2012/2014/2016 on non-prod and Production Environments.

●Upgrades of SQL Server 2005/2008R2/2012 to SQL 2012/2016.

●Install SQL server 2012/2014/2016 in a standalone/clustered on virtual/physical environments

●Migrate SQL server from Physical to Virtual servers as a part of virtualization project

●Always-on setup on same subnet and multi subnet cluster for HADR.

●Added SQL Server Always-On Availability groups to Existing Failover Clusters.

●Disaster Recovery Planning, Testing, analyzing and continuous update of documentation.

●Implemented Database Mirroring and Log Shipping as a part of DR plan.

●Implemented Transactional Replication from Multiple Publishers to Subscriber.

●Developed and Implemented Cloud Formation template to OS automate the infrastructure and SQL Builds.

●Built and Migrated SQL2012 Databases from on Premises to AWS EC2 and RDS.

●Installed and configured SCCM 2012 (Microsoft System Center Configuration Manager).

●Automated windows and SQL patches on DB servers using SCCM 2012.

●Handled up to 30 TB Size databases with clustered and standalone environments.

●Implements and Supports database security regulations, policies and guidelines.

●Modify Stored Procedures and complex T-SQL Queries to improve query execution process.

●Troubleshooting performance issues with slow running queries and applications by looking at execution plans.

●Creating Logins and Roles with appropriate permissions.

●Creating and Maintaining Database Maintenance Plans.

●Using SQL Server Profiler and Extended Events to fix the performance issues

●Import data across multiple instances using BULK INSERT and BCP Utility.

●Plan and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.

●Worked with DTS Packages to load the massaged data into Data Warehousing System.

●Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.

●Involved in Capacity Planning, Database Normalization and De-normalization process.

●Optimized the database server using DMV’s and DMF’s and perform a code review and tuning for the best performance of the application.

●Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

●Mentored team members to optimize SQL Queries.

●Configured Windows Failover Clustering and SQL Clustering on Multi Subnet Cluster.

●Set up Change data capture (CDC) on the production databases.

●Deployment of databases, jobs from pre-production to production.

●Scheduling Backups/restores and doing point in time restores when needed.

●Configured Snapshot Replication and Transactional replication and troubleshooting issue.

●Upgrades and applying patches and hot fixes.

●Adding nodes to already existing clustered servers as a part of data load/High availability

●Configured Transactional Replication and Log Shipping with SQL Server Management

●Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.

●Work with application vendors for building new application databases.

●Work on weekly Issues reports which are generated as a part of infrastructure setup.

●Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans

●Configured Database mail, linked servers.

●Extensively worked on Transparent Data Encryption (TDE) and Auditing.

●Performance tuning of databases by windows performance monitor and SQL Profiler

●Used Index tuning wizard to redesign and created the indexes for better performance.

●Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

●Used the PowerShell scripting to get the most consistent production environment.

●Disaster Recovery Planning, Testing and Analyzing and continuous update of documentation.

●Documenting the standard procedures on regular basis.

●Working on tickets/incidents with in the SLA’s, as a part of operations support DBA

●Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.

●Resource planning and coordination for application migrations with project managers, application and web app teams

●Involved in all ITIL process like Change management, Incident Management & Problem Management.

●24*7 on-call production support

Kellogg Brown & Root (KBR), Houston, TX. May 2015 – Oct 2016

Sr. SQL Server DBA

Description: KBR is a global provider of differentiated professional services and technologies across the asset and program life cycle within the Hydrocarbons and Government Services Sectors.

Environment:

Microsoft Windows 2003/2008R2/2012 Server, Microsoft SQL Server 2005/2008 (R2)/2012/2014

Responsibilities:

●Installed and configured SQL Server 2005/2008R2/2012/2014 on Virtual and physical servers.

●Create and maintain various databases for Production and non-prod MS SQL Server 2005/2008R2/2012/2014.

●Conducted root cause analysis of application unavailability and narrow down the issues related to coding practices, database bottlenecks, or network latency.

●Resolve locking and blocking issues.

●Configure Memory for optimal performance.

●Always-on setup on same subnet and multi subnet cluster for HADR.

●Added SQL Server Always-On Availability groups to Existing Failover Clusters.

●Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery

●Use windows performance counters and SQL profiler trace to capture server related data

●Tuning TSQL queries using execution plan for optimal query performance

●Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.

●using IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.

●Monitoring SQL Server logs, Application logs and analyzing the logs.

●Providing 24*7 support to SQL application developers in implementing the applications on production server.

●Reorganizing or Rebuilding Indexes based on the Index fragmentation

●Restores/refreshes to non-prod from production servers

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

●Creating Backup strategies and scheduling them as a part of database maintenance plans.

●Created the SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.

●Involved in Performance Tuning for source databases, target databases

Fifth Third Bank Cincinnati, OH, US Nov 2013 – April 2015

Sr. SQL Server DBA/Developer

Description: Fifth Third Bank is a bank headquartered in Cincinnati, Ohio, at Fifth Third Center. It is the principal subsidiary of Fifth Third Bancorp, a bank holding company.

Environment: MS SQL SERVER 2000/2005/2008R2/2012, WINOWS SERVER 2003/2008/2012.

Responsibilities:

●Migrate SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008/2008R2/2012 databases by In-place upgrade and side by side upgrade.

●Setup and monitor transactional replication, Database mirroring on Production, QA and Development servers.

●Migrated DTS packages into SSIS packages.

●Handled up to 10 TB Size databases with clustered and standalone environments

●Configured Transactional replication on migrated server.

●Implemented Always-on setup and Configured high Available groups.

●Added SQL Server Always-On Availability groups to Existing Failover Clusters.

●Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.

●Wrote the packages using SSIS in SQL 2008/2008R2/2012.

●Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).

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

●Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.

●Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.

●Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).

●Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.

●Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.

●Used DTS packages to move logins and jobs from one server to another server.

●Used log shipping for synchronization of database.

●Good experience in data modeling and metadata services.

●Monitoring SQL server performance using profiler to find performance and deadlocks.

●Created Stored Procedures, Triggers, Views and Functions for the Application.

●Extensive testing on the Performance of the Stored Procedures.

Invista Houston, TX, US July 2012 – Oct 2013

SQL Server Administrator/Developer

Description: Invista, headquartered in Wichita, Kansas, United States, is a major integrated fiber, resin and intermediates company. It has about 10,000 employees in over 20 countries worldwide. The predecessor DuPont Textiles and Interiors was formed from DuPont's textile fibers division in 2003.

Environment:

MS SQL Server 2005/2008/2008R2/2012, IIS Server 5.0, Windows 2000/2003/2008/2012 servers, Outlook Express, .NET, MS Access.

Responsibilities:

Install, Manage and administer SQL server 2000/2005/2008/R2/2012 servers.

Migrations of databases from SQL 2005 & 2008 to SQL 2008/SQL 2012.

Deployment of databases, jobs, cubes from pre-production to production.

Building SQL 2005/2008 cluster environments on VMware or Physical windows servers.

Performed installations of SQL 2005/2008/2012 on clustered and standalone servers

Upgradations of SQL server versions and applying patches and hot fixes.

Adding nodes to already existing clustered servers as a part of data load/High availability

Configured Transactional Replication and Log Shipping with SQL Server Management

Implemented and configured Clusters and Replication set-ups on SQL 2005/2008/2012 servers in active-active and Active-Passive node setups.

Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.

SQL Migrations from physical to virtual servers.

Work on weekly Issues reports which are generated as a part of infrastructure setup.

Used IDERA SQL Diagnostic Manager for Performance monitoring, analyzing and troubleshooting.

Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans

Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing

Performance tuning of databases by windows performance monitor and SQL Profiler

Used Index tuning wizard to redesign and created the indexes for better performance.

Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Documenting the standard procedures on regular basis.

Working on tickets/incidents with in the SLA’s, as a part of operations support DBA.

Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration

Resource planning and coordination for application migrations with project managers, application and web app teams

Involved in capacity planning, sizing and database growth projects.

Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes

FactSet Systems, Hyderabad, India July 2008 – Dec 2010

SQL Server Administrator/Developer

Description:

FactSet was founded in 1978 and has been publicly held since 1996. The Company is dual listed on the New York Stock Exchange and the NASDAQ Stock Market under the symbol “FDS.” Fiscal 2015 marked the Company’s 37th year of operation, its 35th consecutive year of revenue growth and its 19th consecutive year of earnings growth as a public company.

Environment:

MS SQL Server 2000/2005/2008/2008R2, IIS Server 5.0, Windows 2000/2003/2008 servers, Outlook Express, .NET, MS Access.

Responsibilities:

●Installing and configuring and tuning and providing 24X7 support for SQL Server 2000, 2005 and 2008 R2 in development and production environments.

●Created and scheduled jobs to setup log shipping between production servers.

●Implemented Database Mirroring on the SQL Server 2008 production databases.

●Job Monitoring and making sure all jobs run successfully every night.

●Creating databases and logins with permissions in SQL Server 2005/2008 as per the developer’s request.

●Worked extensively on SQL Server Reporting Services to generate reports.

●Created Linked Servers between SQL server 2005 and 2008 R2 servers.

●Involved in Migration from SQL Server 2005 to 2008 R2.

●Created Database Diagrams using Erwin Data Modeler.

●Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.

●Migrated and tested DTS packages to SQL Server 2008 Integration Services.

●Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

●Involved in the creation of cubes in the MS SQL Analysis Services.

●Restore Development and Staging databases from production backups as per the requirement.

●Extensively used SSIS to move data from text files to SQL Server.

●Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.

●Prepare daily report on the job failures, backup failures and disk space.

●Extensively used Database Performance Monitoring tools for performance tuning.

●Designed and implemented database maintenance plan.

●Used Index tuning wizard and rebuilding indexes for faster Query Performance.

●Involved in resolving dead lock issues and performance issues.

EDUCATION

Master of Science in Engineering (MS).

Master’s in Business Administration (MBA).



Contact this candidate