Bhushan Kalla

E-Mail: acwcnl@r.postjobfree.com

Phone: 317-***-****

SUMMARY:

** ***** ** ********** ** a DBA Lead and Database developer/ Architect in Various MS SQL Server Versions, Database Physical/Logical Design, Replication Modelling and Implementation, Log Shipping, Windows Clustering, Disaster Recovery Plan implementation, Performance Tuning, Query Optimization, Daily Database Backup and Restore implantation strategies, Database Maintenance Activities, Analysis, and Administration of MS SQL Server 2014/2012/2008/2005/2000/7.0, PostgreSQL, MySQL, DB2 7.1/7.2/8.0, VB.Net/ASP.Net on Windows 2008/2003/XP/2000/NT environment on various Hardware Platforms ranging Enterprise Servers to Intel PC servers.Have experience developing high availability and high scalability enterprise SaaS applications.

Worked in high availability enterprise applications up to "five nines" (99.999%).

Expertise in cloud (SaaS, and PaaS) hosted infrastructure on AWS and Microsoft Azure.

Administered Neverfail tool for high availability.

Worked and managed very large database environments more than 300TB total size.

Experience in leading many database teams in various companies.

Database migration experience from MS SQL Server 2005 to MS SQL Server 2014 (64 bit) on Windows 2012 64bit and SQL Server 2000 32bit to SQL Server 2005 64bit on windows 2003 64 bit.

Automation expert in writing custom scripts to monitor multi server production environments.

Expertise in modelling and implementing transactional replication for more than 100 databases and total databases size is more than 15 Terabytes.

Created SSIS packages and exported them to SQL Server 2008 and 2005 instances. Migrated SQL 2000 DTS packages into SQL Server 2005.

Installed, Configured and Designed SQL Server Report Builder 2.0 and 3.0. Report builder helped business users to create their own reports on a user friendly report designer.

Expertise in table partitioning of large tables in SQL Server 2014, 2008R2, 2008 and 2005.

Implemented Active/Active and Active/Passive windows Clustering and data Replication across the LAN/WAN.

Expertise in writing stored procedures, Triggers, Cursors, User Created Data Types, Views, Rules, Constraints and Meta Data Services Packages.

Experience in working with Production (24 X 7) support.

Created and implemented database backup, restore and disaster recovery procedures.

TECHNICAL SKILLS:

RDBMS/DBMS: MS SQLServer 2014/2012/2008R2/2008/2005/2000, DB2 V7.1, 7.2 and 8.0, PostgreSQL, MySQL

SQL Clients: ErWin, Neverfail, Management Studio, Business Intelligence Development Studio, Enterprise Manager, Security manager, Trace, Service Manager, Upgrade Wizard, SQL Profile and Query Analyzer.

Configuration Tools: OLAP Services, SQL Mail and Database Mail, Data Transfer Services, Log Shipping Replication Architecture and Cluster configuration.

EDUCATION:

Master of Science, Computer Engineering at University of Hartford, CT 06117.

Bachelor of Engineering, Electrical Engineering at Andhra University, India 530026.

PROFESSIONAL EXPERIENCE:

PerfectServe, Knoxville, TN 37932

Senior Database Developer/DBA/ Architect Feb’15– Present

SQL Server 2014, 2008R2, and 2005 64bit tools (Database Engine, Integration Services, Analysis, and Reporting) Enterprise/Standard/Developer edition on Windows 2012 and 2008 64bit operating systems.

Build migration plan from SQL 2005 to 2014 for Always on availability groups (One primary and two secondary replicas: HA and DR availability)

Build new VMs for dev, QA and production database servers and as well as on Microsoft Azure cloud databases.

Worked with development teams to build database design and implementation.

Responsible to review and deploy Database code on pre production and production servers and Microsoft Azure databases.

Expert in database optimization. The production average CPU brought down from 60% to 30%.

Managing HA availability using neverfail.

Automation expert in writing custom scripts to monitor multi server production environments.

Implemented database encryption to critical financial data and credit card data information.

Implemented Database Mail to send notifications about SQL jobs through E-Mails.

Created customized scripts to find SQL Waits, Query Blocking, Kill Blocking Scripts, Auto Space Allocation to the Database Files, and Archiving the old data in the database systems etc…

Created database maintenance jobs such as re-indexing, update statistics, Re-Org, Database Back up, Cleanup Tasks, and Shrink databases.

Helping on daily database activities such as adding new columns, tables, stored procedures, SSIS packages for new development changes.

Used SQL Litespeed for SQL backups and red gate tools for administrative tasks.

Air-Watch, Atlanta, GA 30338

Senior Database Developer/DBA/ Architect Nov’12 – Jan’15

Installed SQL Server 2014, 2012, 2008R2, 2008 and 2005 64bit tools (Database Engine, Integration Services, Analysis, and Reporting) Enterprise/Standard/Developer edition on Windows 2008 and 2003 64bit operating system on shared and dedicated SaaS environments.

Designed logical and physical database models for complex products and features for Airwatch console.

Deploy Airwatch solution on both shared and dedicated SaaS and PaaS cloud database platforms.

Excellent experience in building complex stored procedures.

Worked with multiple teams to build high availability and scalability SaaS applications.

Worked directly with on promise customers and other SaaS customers to provide solutions for application and database issues.

Configured many Active/passive and Active/Active clusters and implemented SQL Server failover.

Implemented Log Shipping, SAN level replication, Failover clustering, Transactional replication for High Availability.

Automation expert in writing custom scripts to monitor multi server production environments.

Installed, Configured and Designed SQL Server Report Builder 2.0 and 3.0. Report builder helped business users to create their own reports on a user friendly report designer.

Implemented database encryption to critical financial data and credit card data information.

Implemented Database Mail to send notifications about SQL jobs through E-Mails.

Created customized scripts to find SQL Waits, Query Blocking, Kill Blocking Scripts, Auto Space Allocation to the Database Files, and Archiving the old data in the database systems etc…

Created database maintenance jobs such as re-indexing, update statistics, Re-Org, Database Back up, Cleanup Tasks, and Shrink databases.

Designed and Implemented log shipping for many dedicated and shared SaaS databases.

Helping on daily database activities such as adding new columns, tables, stored procedures, SSIS packages for new development changes.

CareerBuilder, Norcross, GA 30092

Data warehouse Architect July’07 – Nov’12

Migrated one of the largest SQL Server systems in the world from SQL 2005 to SQL Server 2008 and SQL 2000 to SQL Server 2005 with very minimal downtime to the user side and also migrated the server hardware at the same time of upgrading the SQL Server version.

Configured more than 10 Active/passive and Active/Active clusters and implemented SQL Server failover.

Expert in implementing transactional replication. Ex: the current transactional replication is replicating 6TB of data across multiple servers.

Implemented Log Shipping, Database Mirroring, SAN level replication, Failover clustering, Transactional & Snapshot replication for High Availability.

Worked on MySQL and PostgreSQL databases

Expertise in table partitioning of large tables in SQL Server 2008 & 2005 and created customized scripts for automated YOMO tables.

Installed, Configured and Designed SQL Server Report Builder 2.0. Report builder helped business users to create their own reports on a user friendly report designer.

Created customized backup scripts for various backup models and implemented them across career builder platform.

Implemented database encryption to critical financial data and credit card data information.

Created customized scripts to find SQL Query Blocking, Kill Blocking Scripts, Auto Space Allocation to the Database Files, and Archiving the old data in the database systems etc…

Created database maintenance jobs such as re-indexing, update statistics, Re-Org, Database Back up, Cleanup Tasks, and Shrink databases.

Documented and implemented a disaster recovery for website database systems and financial systems.

Designed and Implemented log shipping for more than 15TB database systems.

Installed third party vendor tools such as SQL Safe for database backups and Apex SQL for Auditing.

Monitor SQL Profiler to eliminate locking/dead locking on tables and enhance system performance.

AT& T (Cingular)

Softpath Systems

Sr. Database Administrator/Architect Jan’05 – June ‘07

Migrated SQL Server 2000 databases to SQL Server 2005.

Installed SQL Server 2005 64bit tools (Database Engine, Integration Services, Analysis, and Reporting) Enterprise edition on Windows 2003 64bit operating system.

Configured two sets of database servers groups; 3 nodes Active/Active/Active and 2 node Active/Active clusters and implemented SQL Server failover.

Expertise in table partitioning of large tables in SQL Server 2005.

Created a data model for customer service reporting system with 21 databases and 416 tables.

Created technical and hardware requirement design documents.

Implemented SQL Mail to send notifications about SQL jobs through E-Mails, Pager messages, Net Send address.

Created database maintenance jobs such as reindexing, update statistics, Re-Org, Database Back up, Cleanup Tasks, and Shrink databases.

Documented and tested disaster recovery manual process.

Created indexed views on SQL Server 2005 for better manageability on secured columns in tables.

Logicsoft, Inc Norfolk, CT

Database Administrator Oct’ 03 – Dec’ 04

Responsibilities:

Led three members database team for state wide voter registration system for State of Indiana.

Organized meetings with state government election team and our development team to collect database requirements.

Created and Implemented logical and physical database model.

Created database Back-up and Restore plans.

Set-up database log shipping to make an additional copy of production database for disaster recovery.

Implemented maintenance plans such as database backups, integrity checks, automatic shrinking, and transaction log backups.

Created various database roles and groups to access and modify the data.

Profiling daily database activities using SQL Profiler and analyse the system performance parameters.

PCC Technology Group, 2 Barnard Lane, Bloomfield, CT 06002

Database Administrator June’ 01 – Dec’ 01

Responsibilities:

Installed DB2 UDB V7.1 in test and production servers, and all developers’ machines.

Involved in creating Database design and implementing in production environment.

Created a test database environment for developers.

Created database objects such as Table spaces, Buffer-Pools, Indexes, Referential Integrity Keys.

Prepared data conversion scripts using ANSI SQL.

Created user login accounts, database roles and permissions.

Administering backup/restore the database and transaction log files.

Implemented database backup and solid disaster recovery procedures.

Involved in creating ER diagrams and transforming the logical data model into the physical data model.

Performance monitoring and trouble-shooting, load balancing performance at the NT and SQL level.

Contact this candidate