HARSHA REDDY
*********.***@*****.***
PROFESSIONAL SUMMARY
Over Ten years of experience in SQL Database Administration, Design, Development & Support of MS SQL Server 2005, 2008/R2, 2012, 2014 and 2016 in Production, Development & VMware Environments.
Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, running DBCC Commands.
Experienced with SQL Azure and cloud base management of databases.
Experience in architecture, administration, management, operations of
Small/medium/large Enterprise under Physical and Virtual computing environments hosted in multi-data centers globally.
Experience in SQL Server performance monitoring using FOG light/SQL DTA, Profiler, Spot light and performance monitor - Analyzing the performance of queries
Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC Utilities, Database Tuning Advisor, Hardware I/O Operations, Recompiling Stored Procedures and Index Maintenance.
Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
Experienced in developing Drill down reports, Drill through reports using SQL Server Reporting Services SSRS, Crystal Reports, and Excel.
Extensive Knowledge in SQL Server Always-on, Clustering, Log Shipping and Replication functionalities.
Experience in implementing many types of High availability and Disaster Recovery solutions like Clustering, Database Mirroring, Cold Standby, Warm Standby, Log Shipping, and Replication.
Setup, Reconfigured, and Monitored log shipping of production databases and also carried out role changes, role reversals, and positioning the monitor server
Performed physical database analysis and feasibility requirements. This involves performance, security, archival, maintenance and recovery requirements.
Experience working with Production (24 x 7) and Development environments
Created Database users, controlling access to SQL Server and making sure right people get access to right data and looking after security issues.
Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
Experience in MDS (Master Data Services), Dimensional Modeling, ER Modeling with hands on ERWIN tool etc.
Strong interpersonal skills, with the ability to easily and effectively interact with
Technical, support and business staff at all levels.
Good Knowledge and Administration skills of Databases like Sybase, Oracle, and DB2.
Excellent interpersonal, analytical and communication skills.
CERTIFICATIONS
MCPID: 6445791
MSDBA: SQL SERVER 2005/2008r2/2012.
ORACLE9i CERTIFIED PROFESSIONAL (2002-03)
EDUCATION:
BACHELORS Degree in Computer Science MADRAS UNIVERSITY / INDIA
MASTERS Degree in Computer Science MONMOUTH UNIVERSITY / USA
TECHNICAL SKILLS
Platforms
Windows XP/NT/ 2000/2003/2008/ 7 server/Vista, Linux, UNIX
Languages
C, C++, T-SQL, PL/SQL, HTML, ASP, PERL, VB Script, Shell
RDBMS
Microsoft SQL Server 2000/2005/2008/R2/2012/2014,2016, MS Access, Analysis Services, My SQL, Oracle
IDE
Microsoft Visual Studio 2003/2005/2008
SQL Server Tools
Enterprise Manager, Management Studio, SQL Profiler, SSIS (ETL), Database Tuning Advisor (DTA), SQL* Plus
Backup Tools
Litespeed, VERITAS, TOAD, SQL Loader, IDERA
Case Tools
MS Office 2000/XP/2003/2010, MS Excel 2000/XP/2003/2010/2013, MS Outlook /2000/2003/2007/2010, MS Visio, MS Project.
PROFFESIONAL EXPERIENCE
Medical Asset Management Inc Jun 16 - Present
Buckhead / GA
Sr. SQL SERVER DBA/Architect
MAMI is nationally recognized healthcare consulting firm that provides consulting and contract coding services for interventional radiology, cardiac catheterization, electrophysiology, vascular surgery and non-vascular interventional procedures for hospitals and physician practices.
RESPONSIBILITIES
Helping the client in design and development of a new effective Relational database and tables from scratch in order to overcome their current issues in the wake of continuous data growth.
INCOMM Apr 15 – Apr 16
ATLANTA / GA
Sr. SQL Server DBA
Incomm is the leader in prepaid card and transaction technologies, products and services including gift, wireless, games, music and Reloadable debit cards and sits on top of this new commerce, offering Industry’s largest prepaid product suite.
RESPONSIBILITIES
Responsible to Manage, Administer, Monitor and troubleshoot of SQL Server 2014/2012\2008\2008R2\2005\2000 in cluster and non-cluster environment.
SQL Server upgrade and migration from version 2005 to SQL Server 2008 and SQL Server 2012
Providing 24/7 on-call support for SQL Server.
Performing Database tuning with application teams to isolate and resolve performance issues.
Working with change control systems to coordinate changes across teams
Experience in Installation, configuring and maintaining Always-on technology in Clustered environment.
Supporting database structure changes and data changes for Application development/testing/deployment.
Development of Internal and external reports for Database growth, Performance and Transaction load using SSRS.
Design and development of data movement packages between SQL Servers and SQL to Oracle using Native tools like SSIS and external tools like Golden Gate and Attunity.
Involved in Implementation and troubleshooting of clustering and Log Shipping as high availability solutions in 2008, 2008R2 & 2012 servers.
Performing day-to-day operations based on ITIL process: Configuration Management, Incident Management, Problem Management, and Change Management.
Configuring, maintaining and troubleshooting Native SQL Transactional Replication along with external replication tools like Oracle, Goldengate & Attunity.
Automating Cluster Node availability, error log, blocking, backup Verification\Validation and Connectivity check monitoring for all servers.
Installed, configured and monitored SQL Services using SQL Sentry tool.
Planned and executed database growth report, used for capacity planning.
Thorough code review before applying any changes in PRD environment.
Assessing of database security, and perform necessary action to protect database such as Security patching, remove unnecessary privilege, and get the customer to sign Risk Acceptance Form.
Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.
Specialized in all aspects of database design and programming with Sybase Adaptive Server Enterprise, Replication server and Sybase IQ Server and Oracle.
Experience in developing Unix Shell Scripts for automation of ETL process.
ENVIRONMENT:
MS SQL Server 2014/2012/2008 R2/2008/2005, Sybase, T-SQL, MS SQL Server Services, (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2012/2008/2003 server, Visual Studio, .Net Framework, & Quest Lite Speed backup tool and Oracle Golden Gate & Attunity Replication, Power Shell, MDS (Master Data Services).
Centurion Medical Products May 14 – Feb 15
Lansing/MI
Sr. SQL SERVER DBA/Architect
Centurion Medical Products has been at the forefront of developing programs and products that help healthcare providers optimize the profitability of their green initiatives. Centurion offers free collection and pick up of used medical instruments, eliminating instrument disposal costs, reducing landfill and raw material usage, and issuing cash rebates for returned instruments.
RESPONSIBILITIES
Responsible for Installation, Configuration and Administration of MSSQL Server 2008/2008 R2/2012 on windows 2003/2008 Servers.
Monitoring and Troubleshooting jobs in Production, QA and Development environment.
Responsible for upgrades, patches and fixes.
Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
Assisted in the design and development of the data warehouse
Design and implement Backups and Restore database policies.
Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
Responsible to implement and monitor security for the SQL Server Environment.
Monitoring and Troubleshooting jobs in Production, QA and Development environment.
Setup Deadlock and Blocking chain monitoring alerts for critical OLTP systems.
Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.
Worked on PowerShell Scripts in order to convert incoming Excel Flat files from .xls to .csv which helps importing into Informatica.
Provided on call 24/7 Support on weekly basis.
ENVIRONMENT: MS SQL SERVER 2005/2008 R2, SharePoint, Red Gate, Windows 2000/2003/2008/7, SAP Environment, Shell Scripts, Batch Scripts.
INCOMM JUL 13 – Mar 14
ATLANTA / GA
Sr. SQL Server DBA
Incomm is the leader in prepaid card and transaction technologies, products and services including gift, wireless, games, music and Reloadable debit cards and sits on top of this new commerce, offering Industry’s largest prepaid product suite.
RESPONSIBILITIES
Involved in performance testing and optimization of a 4TB OLTP Database.
Helped in Query optimization and improving the overall performance.
Monitored and troubleshooting of Database Buffer Latch contention.
Worked with tools like Litespeed for Backups and SQL Sentry Tool for monitoring the servers.
Prepared MIS Report, which gives the size and frequency of database growth, used for capacity planning.
Helped in improving the number of Transaction per second (TPS) writing to a database without any high impact of latches or CPU usage.
Migrated SQL Server Production Databases using Log Shipping with minimal downtime.
Installed on configured Attunity Replication Tool for replicating data from one server to other using CDC change data capture.
Used and Maintained Golden Gate Replication for SQL Server and resolved the replication issues raised.
Helped in setting up Archival process for Production DB tables which has more than 200 Million records of data.
Developed Powershell scripts to automate various tasks
ENVIRONMENT: MS SQL SERVER 2005/2008 R2/2012, Sybase, SharePoint, Attunity, Golden Gate, Litespeed, SQL Sentry, Red Gate, Lisa Simulation Tool, Windows 2000/2003/2008, Powershell and Batch Scripts.
SHIRE Pharmaceuticals OCT 12 – JUL 13
WAYNE / PA
Sr. SQL Server DBA/Architect
Designing and Developing standards and administration process flows for Database environments ORACLE/SQL Server, which has to be followed by Operational DBA’s of SHIRE.
RESPONSIBILITIES
Plan, Design and Developing the Implementation of Databases Re-Architecture.
Provide 24/7 support in Monitoring, Maintenance and Planning of the database servers and their availability.
Helping out with creating, recommending and defining tools, standards and best practices all over the enterprise.
Planning and Implementing High Availability and Disaster Recovery solution without interruption.
Designing and planning on Implementing Virtualization (V-Block) to reduce IT cost and improve productivity.
Designing process flow and creating templates for each and every service used and provided.
Helping the client in creating and deploying a stable database domain.
Installed and Configured SQL Server 2008 R2 on Windows server 2008.
Installed and Configured OEM 12C for monitoring Oracle and SQL Server Databases from one centralized location.
Installed and configured Net backup Tool to perform backups for SQL Server Databases.
Worked with Microsoft Team to run RAAS assessment tool and make sure all configuration policies and standards are followed.
Developed Standard Operation Protocols (SOP) to be followed by Operational DBA's of SHIRE.
Developed Windows Powershell script to automate setting of user credentials and activation of Windows
Subscribe SQL Server Azure Cloud services and created and managed databases
ENVIRONMENT: MS SQL SERVER 2005/2008, SQL AZURE, ORACLE 11G, Oracle Enterprise Manager OEM12C, Teradata SharePoint, RMAN, NET BACK-UP, Windows 2000/2003, Mantis, V-block.
JPMORGAN CHASE JUL 11 – AUG 12
CHICAGO / IL
SQL Server DBA / Designer
Design and developed the automation of Commercial Card Rebate Application database for a number of government agencies for their employee credit card programs.
RESPONSIBILITIES
Installed and configured MS SQL Server 2005. Edited the server registration properties, Created Logins, Managed the object level permissions and security issues of the server.
Involved in Design and development of the Application database which help to calculate Rebate Payment to clients.
Worked closely with Business experts and Business analyst to define and analyzing the business requirement and converting them to database requirements.
Supported Engineering on approach of various solutions on implementing Quarterly and Annual based Rebate calculations.
Responsible for Performance Tuning to analyze and optimize costly queries to reduce logical disk I/O for effective performance using SQL server native tools.
Documented several standards and calculations existed in the database and saved them to SharePoint.
Involved in setting up the Backup and Restore strategy for production and other development environments.
Worked on Database schema, table creation, Index creation. Written Stored Procedures, Triggers and functions for effective data integration for business log.
Involved in designing and developing of several internal reports using SSRS.
Built and modified several SSIS packages using BIDS tool.
Involved in Managing and scheduling daily maintenance jobs related to data transfers, Index update, backup and Recovery.
Developed, Produced, Maintained structural design of various systems, applications, and databases for database-driven websites based on business requirements.
Worked closely with Business Analyst (BA) and Business teams in analyzing and approving various changes and updates to database.
Involved in SQL Server 2000 and 2005 service pack and hot fix installations.
Supported to develop, maintain and administer standards for Data, Data bases and Data models.
Involved in Data Modeling for the application and created ER diagram using ERWIN.
Experienced configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMware Environment.
Worked Closely with Application developer and engineers to ensure Integrity and performance analysis of DBMS.
Created different user level groups and assigned appropriate permission level to the database users and maintained Security.
Developed high level design documents DLD’s working closely with BSA to help engineering to understand and implement the code without any discrepancies followed.
Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
ENVIRONMENT: MS SQL SERVER 2000/2005/2008, SQL Azure, MS Visual Studio TFS, SharePoint 2010, SQL Server 2008 BIDS, ERWIN, SSAS, MS WORD 2007, EXCEL.
ROBERT BOSCH LLC FEB 11 – JUL 11
SOUTH BEND / IN, Mt.Prospect / IL
SQL Server Production DBA
The Bosch Group is a leading global supplier of technology and services in the areas of automotive and industrial technology, consumer goods and building technology. Automotive Technology is Bosch’s largest business sector in North America.
RESPONSIBILITIES
Involved in planning and documenting the migration of the Data center.
Responsible for Migrating SQL Server Databases from version 2005 to 2008 using side by side migration.
Experienced in maintaining Spotlight tool for monitoring and troubleshooting issues and alarms raised.
Experienced in setting up Failover Clustering and helped in maintaining and troubleshooting the cluster environment.
Involved in configuring and monitoring Transactional Replication for reporting purpose.
Experienced on working and answering Incident management and Change management tickets On BMC Remedy and IT Service Management ITSM.
Experience working with TSM Tivoli Storage Manager and UC4 scheduler for backups.
Experience working on DMZ servers.
Involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
Experience in improving SQL Server performance by using Index tuning wizards, performance tuning methods, execution plans and SQL Profiler.
Responsible for SSRS Installation and configuration.
Involved in Performance tuning of slow running SQL queries and stored procedures and helped in redesigning them.
Individually responsible for monitoring and maintaining the Clustered servers.
Provided 24/7 dedicated support for deployment in Development and Production environment.
Worked with several users and vendors from Mexico/Germany/Brazil and India supporting their Application Database issues 24/7.
ENVIRONMENT: MS SQL SERVER 7.0/2000/2005/2008, MS VISUAL STUDIO TFS, SHARE POINT, VSS, Remedy Tool, UC4 Scheduler, Tivoli Storage Manager (TSM), PowerShell.
FORT KNOX NATIONAL COMPANY MAR 10 – JAN 11
ELIZABETHTOWN / KY
SQL Server DBA
Fort Knox National Company is the source for convenience bill payment options for their customers. It is a leader in consumer-to-business bill payment services for utility, mortgage
And financial services and the nation's largest processor of automatic payroll deductions for U.S. military and federal civil service employees.
RESPOSIBILITIES
Installed configured and maintained SQL Server 2008 on windows server 2008.
Involved in developing Logical and physical design, and Architecture of a financial database for PAYROLL BILL PAY system.
Installed configured and developed Internal Reports using 2008 SQL Server Reporting Services in a Data warehouse environment.
Implemented configured and maintained Transactional replication successfully in SQL Server 2008 environment.
Implemented purge process for the data on transactional servers.
Involved from scratch in Designing, Developing and Change Management of the financial website Application.
Individually Responsible to verify and analyze all the SQL scripts and to store them in VSS.
Created DB objects like Tables, Views, Indexes, Complex Stored procedures & triggers using T-SQL.
Implemented a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space).
Provided 24/7 dedicated support for deployment in Development and Production environment.
Migrated databases to other servers, created logins, set up database mail, alerts and maintained overall security.
Perform day to day Database Maintenance tasks like Database Monitoring, Backups, Space Management, Resource Utilization for performing object migration between all production database Servers.
Responsible for installation of patches and hot fixes for SQL Server 2008.
ENVIRONMENT: MS SQL SERVER 7.0/2000/2005/2008, VISUAL STUDIO, SHARE POINT, Red Gate, Lite Speed, Windows 2000/2003.
FREDDIE MAC NOV 09 – FEB 10
MC LEAN / VA
SQL Server Production DBA
Helps millions of families and neighborhoods across America buy their own homes or enjoy quality and affordable rental housing by linking them to the world's capital markets. It is a unique mortgage finance system that makes homeownership a reality for most of the America's families.
RESPONSIBILITIES
Working on BSC Remediation project to maintain security all over SQL Server platform for Implementation data. BSC (Baseline Security Configurations).
Installed configured and maintained SQL SERVER 2005 on windows server 2003.
Involved in writing several Batch Files and C++, shell scripts which helps in maintaining Securities, Standards and restricting invalid access to SQL Server by sending an e-mail to DMSS Audit on multiple servers.
Experienced in monitoring servers using System Centre Configuration Operation Manager (SCOM) 2007.
Expertise in using Windows Script Host and converting VB script to Batch Files.
Experienced working on Remedy Ticket system for solving issues and concerns of ETL and development Teams.
Working on creating and Implementing Standard Operation Protocols (SOP’s) for SQL Server and documented them in clear case.
Experienced with working and using Clear Case and Clear Quest tools.
Involved in upgrading SQL Server 2000 to SQL Server 2005 and converted all remote servers to Linked servers except those involved in Replication.
Involved in Performing Backups for development and production databases and automated the process using AUTOSYS.
Experienced in setting up SQL Jobs, Operators, Alerts, Notifications, Database and SQL Mail Profile. Used Autosys for scheduling the jobs.
ENVIRONMENT: MS SQL Server 2000/2005, ORACLE 11g, Clear Case, Clear Quest, Remedy, SSIS, .NET Framework, C#, Windows 2000/2003, SharePoint.
CPA GLOBAL
ALEXANDRIA / VA FEB 09 – OCT 09
SQL Server Production DBA
CPA Global was set up by patent attorneys from different UK firms. They had the vision to provide an intellectual property renewals service specializing in patents. Those attorneys have a personal stake in ensuring the quality and development of our offering.
RESPONSIBILITIES
Installed and configured SQL Server 2008 on windows server 2008.
Migrated SQL Server 2005 databases to MS SQL SERVER 2008.
Worked on a large database which is of 4TB in size.
Experienced working on Microsoft Visual Studio Team System 2008 (Data Dude).
Implemented stored procedures for fielded search lookups.
Created Logins. Managed the object level permissions and security issues of the server.
Worked on synchronization of schema in QA and DEV databases those are not in a network.
Created complex SSIS Packages for Data Migration and Transformation from one server to another server.
Created different user level groups and assigned appropriate permission level to the database.
Provided 24/7 dedicated support for deployment in Development and Production environment.
Helped and assisted the development team in Puerto rico providing 24/7 support.
Implemented and Maintained security all over the organization.
Worked on improving the performance of stored procedures by creating indexes and updating statistics.
Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005/2008.
ENVIRONMENT: MS SQL Server 2008/2005, Data Dude, .NET Framework, SSIS, ASP .NET, SharePoint Server, SSRS, SVN, C# .NET, SSL, IIS 6.0/7.0, Windows 2008/2003, Erwin, Excel, SQL Prompt.
CITIGROUP
NEW YORK CITY / NY OCT 07 – JAN 09
SQL Server Production DBA
The Database Group provides business aligned production (and some non-production) support to various Citigroup departments for Sybase, MS SQL Server and Oracle. My Position is a FICC Database Administrator that includes management of project work and management of the production database environment for the FICC business.
RESPONSIBILITIES
Installed and configured SQL Server 2005 on windows 2003, and applied service packs.
Involved in migrating SQL server 2000 databases to SQL Server 2005.
Created groups, roles, users and assigning access privileges to users.
Created User defined data types and added them to model database for future purpose.
Setting up database backup and recovery procedures for Production, QA and Development servers.
Involved in Data Migration from legacy to master tables using Import and Export wizard.
Implemented the required optimization and fine-tuning of databases. Utilized SQL Profiler to monitor database activity
Installed, configured and maintained SQL Server Clustering on two nodes and multiple nodes and performed the failover process from active to passive nodes.
Production experience in Microsoft Cluster Services (MSCS), including Active/Passive, Active/Active, and Network Load Balancing clusters.
Responsible for Query optimization and Performance tuning, SQL queries using Show Execution Plans.
Generated Transactional replication, pulled subscription and defined edition to transfer data from branch to head office and vice versa.
Acted as an Independent lead database architect for the ETL process design
ENVIRONMENT: MS SQL Server 2000/2005, Linux, ORACLE 10g, .NET Framework, VSS (Visual Source Safe), SSIS, Windows 2000/2003, Erwin, VB Script, SQL Prompt.
T- MOBILE
PARSIPANNY/NJ OCT 06 – AUG 07
SQL Server DBA/Developer
Inventory Management System- Sales automation deals with the Inventory & Material management, Order Processing and Print schedules. The front-end provides user-friendly interfaces, Invoice report generation and Order processing information.
RESPONSIBILITIES
Migrated SQL Server 2000 to SQL Server 2005.
Actively involved in creation of database, modified tables, DDL triggers, and store procedures to clean and validate the data to meet the company specifications.
Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Designed new SSIS packages as per needs, Resolve the problems.
Created Backups Strategies for databases and automated the process.
Experienced with vertical partitions, horizontal partitioning, subscriber options, and types of replication scenarios, Central Publisher, Central Publisher using remote distributor, Central Subscriber and replication topology.
Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
Data migration between different environments and Third Party Databases.
Written stored procedures for automatic scripting to backup transaction logs, log file, maintain archive of objects and so on.
Experienced in writing C++ scripts for performing backups and to maintain the automation of jobs on multiple servers.
ENVIRONMENT: SQL Server 2005/2000, .NET Framework, ADO.NET, ORACLE 10g, Visual Studio, Windows (2003, 2000/4.0), SSL, IIS 5.0, SQL Server 2000/7.0, UNIX.