Sql Server Database

Kumar Thammali

Phone: 224-***-****

E-mail: **********@*****.***

Professional Summary:

8years of IT experience in SQL Server as Database Administrator.

Experience in Installation, Configuration, Maintenance, Troubleshooting, Design, Development, Management and Support of MS SQL Servers 2014, 2012, 2008R2, 2008, 2005,2000 in Production, QA and Development Environments.

In depth knowledge in SQL Server backup, Capacity planning and recovery, Can plan effective backup strategy as per the environment needs.

Experienced in managing very large production Databases.

Troubleshooting SQL Server performance issues and worked on areas for improvement in Database objects code, storage and indexes.

Creation of database maintenance plans, rebuild/defrag indexes and database consistency checks.

Migrated databases and upgraded the versions from SQL Server 2005 to 2008, 2005 to 2012, 2008R2 to 2012 and 2012 to 2014.

Set up and maintain database environments to support production, QA and development activities.

Experience in migration of Data from different sources like Excel, Flat file, DB2, Sybase, Oracle, MySQL to MS SQL Server by using SQL Server Integration Services (SSIS), BCP, Back Office/Cransoft technologies, Bulk Insert and DTS(Export/Import)utility.

Configured and implemented High availability and disaster recovery in SQL Servers using Always On, Database Replication, Clustering and log shipping.

Managing Security related tasks such as Creating users, logins, roles and granting permissions on daily basis.

Experience in configuring Database Mirroring and ensuring high Availability to the databases by testing the failover.

Providing 24/7 on Call Support for Production Databases.

Experience in Creating jobs, alerts, log to monitor the database errors.

Creating Database objects such as tables, views, Rules, Defaults, indexes, partitioning, Update statistics and constraints.

Strong knowledge on creating procedures, triggers, functions, transactions and cursors using T-SQL.

Writing complex SQL Queries using Joins and sub queries.

Good Knowledge of BI Tools such as SSAS, SSIS and SSRS.

Developing Power shell scripts to automate tasks.

Experience in usage of System/User-Defined Data types, Transact-SQL Functions, System procedures, dbcc stored procedures and global Variables.

Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).

Fixing the data quality issues in Production.

Monitoring and solving tickets on time which users raise in GE tool for support without missing SLA’s.

Creating and Managing Audits with Transact-SQL and SQL server Management studio.

Highly experienced in strategically implementing indexes such as clustered index, non-clustered index on data structures to achieve faster data retrieval.

Have Interest in designing/crafting efficient modern software’s and learning new technologies/tools if need arises.

Professional Experience:

Senior SQL Server DBA

Client: General Electric (GE), Greenville, SC

Feb 2014 to Present

Managing SQL Servers in production, development and QA environments.

Monitoring the complete environment for resource utilizations and to avoid any bottlenecks.

Creating and maintaining various databases on Production, development and QA environments using SQL Server 2014/2012/2008R2/2008/2005.

Created jobs to import/ export data obtained from various Sources to update the SQL servers.

Installed and configured SQL Server Reporting Services.

Installed necessary Service Packs for SQL server 2005/2008R2/2012.

Database Log Backups and restores, backup strategies and scheduling backups.

Implemented high availability on the various servers using replication/mirroring/Clustering/ Always On.

Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.

Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.

Contacted various users in gathering the requirements and documented the necessary changes.

Migrating legacy systems applications data to Target Sql server application using SQL Server Integration Services (SSIS), BCP, Back Office/Cransoft technologies, bulk insert and DTS utility.

Automation of data exports/imports using SSIS.

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

Troubleshoot production database server, user administration, configure SQL Server, creating databases for development and testing environments, capacity planning, performance tuning and database monitoring.

Worked on Log shipping to create Stand-by Server.

Job Monitoring and making sure all jobs ran successfully every day.

Creating and managing schema objects such as tables, views, indexes, procedures, triggers and constraints.

Perform recovery of the database, Import table’s schema as requested.

Actively involved in migrating the databases and upgrading the versions from SQL Server 2005 to 2008, 2005 to 2012, 2008R2 to 2012 and 2012 to 2014.

Monitoring and fixing replication issues.

Managing security on Production and Development environments. Administering the MS SQL server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.

Created triggers, constraints to maintain the referential integrity.

Developed the procedures, cursors, transactions Using T-SQL.

Environment: MS SQL Server 2014/2012/2008R2/2008/2005,MS Access, Oracle 9i/11g,Sybase 16.0/15.7, Windows 2012R2/2008R2/2003,SQL,TSQL,PL/SQL, ERWIN, SQL Profiler, UNIX Putty, Business Intelligent technologies SSIS, SSRS, SSAS, GE Service Now, Sqldbx, WIN ISQL,SQL Developer, SQL Plus, SQL Server Management Studio and Back Office/Cransoft technologies.

Senior SQL Server DBA

Client: General Electric (GE), Schenectady, NY

Jan 2013 to Jan 2014

Maintaining production databases, supporting development and QA environments.

Clustered and non-clustered index creation/optimization using SQL Profiler and Index Tuning Wizard.

Created and maintained technical documentation.

Created jobs, alerts, log to monitor the database errors.

Involved in various stages like development, Testing and Support.

Migrated databases from one server to other servers.

Transfer Logins to another SQL Server or Instance.

Implemented high availability on the various servers using replication/mirroring/Clustering/ Always On.

Support for ongoing database issues which users raised in GE tool.

Daily routine DBA tasks like handling user's permissions and space issues on Production.

Used SSIS/DTS/Back office to Export/Import data from different legacy source systems to target SQL server application.

Design and normalize the databases and created different objects such as tables, views, rules, defaults, functions, triggers, stored Procedures, Production Code Deployment and handling concurrent user requests.

Using SQL server Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health.

Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.

Performing regular consistency checks for database consistency using DBCC commands and re-index/index-defrag tables on a scheduled basis.

Monitoring and fixing replication issues.

Handling maintenance Jobs including Database Log Backups and restoration, backup strategies and scheduling backups.

Environment: MS SQL Server 2012/2008R2/2008/2005, SQL, TSQL, PL/SQL, Oracle 9i/11g,Sybase 15.7/15.5,BI Tools SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio, MS Excel, Windows 2012/2008R2/2003, ERWIN, SQL Profiler, UNIX Putty, GE Service Now, Sqldbx, WIN ISQL, SQL Developer, SQL Plus, SQL Server Management Studio and Back Office/Cransoft technologies.

SQL Server DBA at Tech Mahindra Limited

Client: General Electric (GE), Hyderabad, India

July 2008 to Dec 2012

Installed, configured and managed SQL Server (2000, 2005, 2008 and 2008R2) in development, test and production servers.

Migrated databases from lower SQL Server Edition to latest SQL Server Editions (2005 and 2008R2).

Created databases, tables, columns, indexes, views and designed relationship between tables.

Created logins, groups, users, roles, and implemented SQL Server security policy.

Conducted code reviews adding/changing tables for data loads, data extraction and documented a tested program code for future use.

Troubleshot SQL Server performance issues and conducted performance tuning, checking for database integrity, fixing DBCC command generated errors, monitoring error logs, database space allocations and transaction log space allocations.

Setup job automations and monitored jobs, created notifications for backup failures, system errors, insufficient resources, fatal database errors and hardware errors.

Automated and enhanced daily administrative tasks including space management, object alteration, backup, recovery and performance monitoring.

Designed and implemented high availability solutions: Always On, database mirroring and log shipping.

Configured replicas for read-only secondary database copies.

Data migrations using bulk insert, exported & imported records from text flat files and excel into SQL server databases.

Created SSIS packages and deployed packages, configured job automations and migrated the packages.

Created ad-hoc reports using SSRS and deployed reports.

Database Performance Tuning.

Monitoring all servers regularly to check long run Trans, blocks, log & errors.

Granting user permission user and roles to database on the SQL server objects.

Involved in Production releases and Coordinating with developers to move database changes into production.

Running weekly maintenance task like Dbcc check Storage, re-org rebuild and update statistics.

Identifying the daily backup jobs failure, trouble shoot and fixing.

Supporting 24/7 on call production support on rotation basis.

Monitoring and solving tickets on time which users raise in GE tool for support.

Set up and maintain database environments to support production, QA and development activities.

Maintains database objects such as tables, views, indexes, partitioning, Stored Procedures, Triggers, constraints based on analysis of application requirements.

Developed the procedures, triggers, cursors functions and transactions using T-SQL.

Environment: MS SQL Server 2008R2/2008/2005/2000, SQL, T-SQL, MS Access, PL/SQL, MS Excel, Business Intelligent technologies SSIS, SSRS, SSAS, Windows 2008R2/2008/2003, ERWIN, SQL Profiler, Oracle 9i/11g,Sybase 12.5/15.0,UNIX Putty, HPSD,GE Service Now, Sqldbx, WIN ISQL, SQL Developer, SQL Plus, SQL Server Management Studio and Back Office/Cransoft technologies.

Education:

Bachelor of Technology 2007, Jawaharlal Nehru Technological University, Hyderabad, India

Contact this candidate