PRAVEEN TALLURI

SQL Server DBA/Developer

Email: ac276u@r.postjobfree.com

Phone: 908-***-****

Summary:

4+ years of SQL Server DBA experience with Managing SQL Server environment

Knowledge of Relational database management system (RDBMS).

Experience of features in SQL Server 2012 like Always on High Availability and Container Database.

Experience in installation and working with windows 2003/2008/2012 servers.

Experience in upgrading and migration from SQL 2000-> SQL 2005->SQL 2008->SQL 2012/2014.

Installation experience in SQL 2012, SQL 2008/2005 and SQL 2000.

Skillful with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups with compression.

Experience about data compression and database backup compression feature in sql server 2008/2012/2014.

Experience in developing and managing Stored Procedures, Triggers, Indexes, Schemas, Views, Data Transformation Services and Locking.

Proficient with database backup and recovery procedures, disaster recovery solutions using log shipping and database mirroring and also high availability solutions like Multi Node clustering (Active/Active and Active/Passive)and Replication (snapshot, transactional, merge).

Experience with Database mirroring between production and disaster recovery servers.

Experience in writing and reviewing T-SQL code, maintaining coding standards across the board in all SQL Server environments.

Migration of data from flat files and excel source to MS SQL server using DTS and SSIS by extract, transform and load method.

Database creation and Manage with Creating roles and user permissions.

Wide experience in Capacity planning, Performance Tuning, Disaster Recovery, backup and restore procedures.

Experience in using Data Partitioning for large tables of data to increase performance.

Extensively worked and had good knowledge on SSIS good experience in data migration from Access/Excel Sheets to SQL Server 2014/2012/2008/2005/2000(SSIS)

Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive working relationships in internal, external, independent and team environment.

Skills:

Operating Systems: Windows 2012/2008 R2/2005, Windows XP/ Professional, Linux

RDBMS: SQL Server 2014/2012/2008R2/2008/2005, MS Access

Database: Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS, Power BI

Tools: SQL Server Reporting Services, Red Gate, Idera, Red Shift

Applications: Microsoft Office, MS VISIO 2003/2005, PowerShell, Excel

Professional Experience

Project: Affinitiv, Los Angeles, CA June 2017 – Present

Role: MS SQL Server DBA/Developer

Affinitiv is a marketing technology company built on advanced analytics and a leading-edge technology platform, enabling car manufacturers (OEMs) and dealers to produce, manage, measure, and optimize multi-channel communications. Affinitiv has the largest number of preferred OEM relationships in the market and is currently working with more than 5,500 dealerships.

Roles & Responsibilities:

Installed, configured and migrated SQL Server 2014,2012, 2008 R2 and SQL Server 2005 on windows 2012/2008 R2 and 2008 servers, applied service packs and security fix for all servers.

Installing/Configuring Patching SQL Server 2014/2012/2008 R2

Participated in setting up DR and HA with SQL Server CLUSTERING, MIRRORING and LOG SHIPPING.

Implemented Database Mirroring on SQL Server 2012 environments.

Implemented transactional replication for data refresh

Managed all Publisher, Distributor and Subscriber database environments for the replication

Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2

Installed and configured Mirroring for Production and DR environments

Setup Log Shipping for production databases to carry out DR and failover

Managed virtualized Databases on VM ware.

Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)

Implemented backup and recovery processes

Performed routine maintenance on databases; monitored and tuned databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views; implemented and maintained security rules and security audits; maintained state of audit readiness; problem resolution.

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

Experience in deploying databases to the Azure.

Used DMV’s for finding Index Fragmentation and Worst performing Queries

Creating, Scheduling and deploying SSIS packages.

Performance tuning, and optimization of procedures and queries.

Developed, documented and maintained data models in Erwin for relational database administration.

Worked a lot on creating, designing databases and creating Views, Stored Procs and Triggers

Used Various third Party tools for monitoring SQL Servers and Backing up Databases

Partly Participated in system study and analysis of software applications.

Experienced in support, applications and software development.

Environment: Windows 2012/2008 R2/2003 Server, MS SQL Server 2014,2014, 2008r2 and 2005.T-SQL, SSMA, RedGate, Idera SQL Safe backup, ETL, DTS, SSIS, SSRS,SSAS, Mysql, Red Shift,VM ware, Performance Monitor, UNIX, AWS, SQL Profiler, Azure, Powershell

Project: IBM, Poughkeepsie, NY Sep 2014 – May 2017

Role: MS SQL Server DBA

Staples, Inc. is a large office supply chain store, with over 2,000 stores worldwide in 26 countries.

Roles & Responsibilities:

Installed, configured and migrated SQL Server 2014,2012, 2008 R2 and SQL Server 2005 on windows 2012/2008 R2 and 2008 servers, applied service packs and security fix for all servers.

Involved in Migrating SQL Server databases to the new SQL Server 2014 version.

Installing/Configuring Patching SQL Server 2014/2012/2008 R2

Involved in development activities including hardware installation and configuration, and participation in database design and architecture.

Participated in setting up DR and HA with SQL Server CLUSTERING, MIRRORING and LOG SHIPPING.

Implemented Database Mirroring on SQL Server 2008 environments.

Implemented transactional replication for data refresh

Managed all Publisher, Distributor and Subscriber database environments for the replication

Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries

Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2

Upgraded SQL Server 2005/2000 to SQL Server 2012/2008R2

Installed and configured Async and Sync Mirroring for Production and DR environments

Setup Log Shipping for production databases to carry out DR and failover

Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)

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

Created stored procedures for Backup and Recovery process.

Experience in deploying databases to the Azure.

Used DMV’s for finding Index Fragmentation and Worst performing Queries

Creating, Scheduling and deploying SSIS packages.

Created extensive reports using SSRS ( Tabular, Matrix )

Performance tuning, and optimization of procedures and queries.

Worked a lot on creating, designing databases and creating Views, Stored Procs and Triggers

Worked hand in Hand with developers to carry out builds and releases.

Used Various third Party tools for monitoring SQL Servers and Backing up Databases

Environment: Windows 2012/2008 R2/2003 Server, MS SQL Server 2012,2008 R2/2005,T-SQL, SSMA, IDera SQL Safe backup, Erwin, ETL, DTS, SSIS, SSRS,SSAS, Mysql, Performance Monitor, UNIX, SQL Profiler, Azure, Powershell

Project: TCS, Hyderabad, India Jan 2013 – July 2014

Role: SQL Server DBA

Citibank is the consumer division of financial services multinational Citigroup. Citibank provides credit cards, mortgages, personal loans, commercial loans, and lines of credit.

Roles & Responsibilities:

Database and Transaction log backups & restoration, backup strategies scheduling backup system for test Databases.

Involved in entire life cycle including database Design, Development, Testing, Optimizing and Deploying on development and production servers.

Logical and Physical design of SQL Server databases using Erwin.

Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.

Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.

Dropped and recreated the Indexes on tables for performance improvements.

Tuned SQL queries using Show Plans and Execution Plans for better performance.

Performing Data Transfer/Migration using Export/Import and Data Transformation Services (DTS).

Load data using Bulk Insert.

Created many complex Stored Procedures / Functions according to business requirements.

Creating and managing schema objects such as Tables, Views, Indexes, Procedures, Clusters, Triggers and maintaining referential integrity.

Environment: MS SQL Server 2005, TSQL

Masters Projects:

●Web Designing – Designed and created a web application called URL shorter using HTML, CSS, Java Script and Java.

●"C" & C++ Programming - used multi-faceted computer programming skills and structured methodology problem solving to resolve a series of typical problems in engineering and technology. Used the logical structures of sequence, decision, and loop in coding programs and the Debugging Facility in the "C" environment. Covered C++ and concepts such as Storage Classes, Bitwise Operators, Arrays, Derived Data Types, Pointers and File I/O

●ORACLE Project Lead – led a team to create a database of records for educational institution. I lead the team, I planned everything how to design database, how to create reports in effective way.

Educational Qualification:

•Master’s Degree in Computer Science, Marist College, Poughkeepsie, NY,2016

Contact this candidate