Prasada Rao Monangi

919-***-**** (mobile) /919-***-**** (Home) adi57c@r.postjobfree.com

PROFESSIONAL SUMMARY

Sr. Database Administrator with expertise in full life cycle development in latest technologies including MS SQL Server, Sybase, PostgreSQL, Oracle and MySQL. Significant experience in architecting and developing mission-critical Internet applications and developing IT strategies. Key strengths are meeting delivery objectives by working with business clients, establishing strong vendor relations and providing exceptional customer service. Results and customer support oriented, personable team player with 15+ years of software industry expertise and exceptional success in designing systems architecture and IT strategies. Authorized to work for any employer (Green Card).

TECHNICAL EXPERTISE

General Management

Database Design, Architecture, Administration, Management and Development

SME and Mentoring Team Members

MS Cluster, Mirroring, Disaster Recovery, Always On & Log Shipping

Performance and Tuning, Security and Replication

SSRS, ProClarity and Business Objects

Web and e-Business Applications

Development, QA, Staging & Production Environments

Database Modeling (Conceptual, Logical & Physical)

Relational Database Management Systems

SSIS, DTS, OLAP and Data warehousing

ETL, Data Scrubbing & Data Conversion

Data Governance, Quality, Profiling, Cleaning

Strategic Planning, Release Management

Certifications

Microsoft SQL Server 2005 – Implementation and Maintenance (070-431).

Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition (070-228).

Microsoft Certification in V.B.6.0.

Brain bench Certification in SQL Server Administration.

Technical Skills

SQLServer2019/2017/2016/2014/2012/2008/R2/2005/2000/7.0/6.5, Sybase 12.5.3, PostgreSQL 11.8/11.5/8.3.2/8.4, Oracle 9i, MySQL, MS Access 2000/97,

Erwin and Visio

ProClarity, Crystal Reports, Business Objects, MOM, Quest and IDERA

Windows2012/2008/2003/2000/98/95/NT, Linux and UNIX.

Virtualized Platforms (ESX)

Azure & AWS

Avamar Backup Tool

Informatica

T-SQL, DDL, DML, DTS, BCP, & OSQL

ASP. Net, VB.Net, C#.Net

HTML, DHTML, VBScript, JavaScript, XML, SOAP, ASP, VB 6.0, C, C++, and PL/SQL

Microsoft IIS Web Server 6.0/5.0.

Dell Power edge Servers R710, 2950, 6800, 6650, 6450, 1650, and 1550.

PROFESSIONAL EXPERIENCE

NORTHROP GRUMMAN INC., RALEIGH, NC (client: USPS) 2015 – Present

Sr. Database Administrator,

Administration, Maintenance, Support of many USPS applications, which include Global Express Delivery, Security, Entrust Token System etc.

Key Accomplishments:

Lead the efforts to Upgrade/Install latest SQL Servers with Service Packs to keep the Database Servers Microsoft complaint.

Managed Database Projects and monitored the status.

Worked on SQL Server 2019/2017/2016/2012 migration from SQL Server 2008 / 2005, Sybase.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expertise in Always-On Availability Groups (AAG) and HA/DR Setup (Log Shipping) and Configuration

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Acted SME in all SQL Server Related Projects.

Strong experience in mentoring team members and writing documentation.

Worked on logical and physical data base modeling with UML and ERWIN tools.

Migrated SQL server 2008/R2 to SQL Server 2012/2016/2017 in Microsoft Windows Server 2012 Enterprise Edition.

Database and log backups, backup strategies, and scheduling backups using Avamar Backup Tool.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Designed and Administered Reports using SSRS.

Working with business operations, implementation and technology teams on a daily basis to implement data changes.

Understand new projects and underlying database components and data flow.

Identifying potential process improvements, and opportunities to streamline procedures.

Investigating potential new tools to reduce triage time and improve results.

Participating in several data standards discussions.

Experience in using tools like SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager

Experience in handling larger size databases.

Capacity Planning, Time management, meeting deadlines and SLAs.

Software

IBM RS/6000 Servers, AIX 5.1, Windows 2016, 2012, 2008, 2003, Windows XP, Virtualized Platforms (ESX).

MS SQL Server 2019/2017/2016/2014/2012/2008/R2, PostgreSQL, Sybase Adaptive Server Enterprise 15.7/12.5.3, MySQL

SSIS, SSRS, SQL Anywhere, T-SQL, Informatica, RSQL740, Rational Clear case, .NET.

FIDELITY INVESTMENTS, RALEIGH, NC 2011 – 2015

Sr. Database Administrator,

Maintenance, Support of DBCS application, which is used to calculate benefits based on sources, plans, rules and other characteristics of participants/beneficiaries.

Key Accomplishments:

Lead the DBA team and Managed Database Projects.

Database Modeling (Conceptual, Logical and Physical).

Worked on SQL Server 2012 migration from Sybase, SQL Server 2008 / 2005 and PostgreSQL.

Design, development of Databases and other objects. Performance Tuning and Query Optimization.

Designed and developed database objects. Tables and Schema design, complex stored procedures using Advanced SQL, Joins and Queries

Database and log backups, backup strategies, and scheduling backups using Avamar Backup Tool.

Installed latest Service Packs to keep the Servers Microsoft complaint.

Architecture the Disaster Recovery Plans including Always ON, DB Mirroring and Log Shipping.

SQL Server Best Practices Analyzer and Microsoft Assessment and Planning (MAP) Toolkit for the purposes of assessing risks and adherence to established standards and best practices in SQL Server.

Designed and Developed Database Replication (Transactional / Snapshot / Merge).

Created ETL Solutions using SSIS/Informatica to transfer data from different sources to destination databases.

Designed and Administered Reports using SSRS.

Understanding the application, individual screens and ability to tie back to a database table and data flow.

Working with business operations, implementation and technology teams on a daily basis to implement data changes.

Tuned number of stored procedures using show plan, statistics time and statistics io.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Identifying potential process improvements, and opportunities to streamline procedures.

Investigating potential new tools to reduce triage time and improve results.

Participating in several data standards discussions.

24 X 7 Production Database on Call Support

Maintained the database health by performing Regular Maintenances and troubleshooting the production issues like performance problems, deadlocks, and I/O bottlenecks.

Played Key role in Production Releases.

Software

IBM RS/6000 Servers, AIX 5.1, Windows 2008, 2003, Windows XP, Virtualized Platforms (ESX).

MS SQL Server 2012/2008/R2/2005, Sybase Adaptive Server Enterprise 15.7/12.5.3, MySQL

SSIS, SSRS, SQL Anywhere, T-SQL, Informatica, RSQL740, Rational Clear case, .NET.

ALLOSO TECHNOLOGIES., RALEIGH, NC 2010 – 2011

Sr. Database Administrator

Administered, and developed Databases of Corporate site for Alloso Technologies, which includes regular database Architecture, Development, Administration and Maintenance.

Key Accomplishments:

Design, development of Databases and other objects.

Performance Tuning and Query Optimization.

Installed, Configured and Upgraded SQL Servers from SQL2000 to SQL2005 and also to SQL 2008/R2, these include both Physical and VMware servers. Also installed latest Service Packs.

Designed and Developed ETL Solutions and SSIS Packages to transfer the data from Excel and Flat Files to Production Servers.

Designed and developed a Decision Support System using OLAP and data warehousing data marts and Cubes.

Designed and Administered Reports using SSRS.

Documentation, Implementation and Maintenance of Processes.

Disaster Recovery Plans including Database and log backups, backup strategies, and scheduling backups using Avamar Backup Tool. Database Mirroring and Log Shipping Setup and implementation.

Database Security and improved the overall Database Performance using Performance and Tuning techniques.

Designed and Developed Database Replication (Transactional / Snapshot / Merge).

Administered and managed multi server production environment and provided 24X7 monitoring and support.

Maintained the database health by performing Regular Maintenances and troubleshooting the production issues (performance problems, Query Optimization, deadlocks, resource issues, I/O bottlenecks).

Designed and Developed database objects, like tables, stored procedures, functions and triggers etc.

Software

Dell Power Edge Servers, Windows 2008 R2 Servers, VMWare, ESX.

MS SQL Server 2008/R2, Oracle 10g/11g

Email2DB, SSIS, T-SQL, SSRS, SSAS, VB Script, PERL, PHP, VB.NET, XML.

CHANNELADVISOR CORPORATION., MORRISVILLE, NC 2009 – 2010

Sr. Database Administrator

Administered, and developed Databases of Corporate and e-Commerce site for Channel Advisor Corporation, which includes regular database Architecture, Migration, Administration and Maintenance.

Key Accomplishments:

Design, development of Databases and other objects. Performance Tuning and Query Optimization.

Designed and developed database objects. Tables and Schema design, complex stored procedures using Advanced SQL, Joins and Queries

Documentation, Implementation and Maintenance of Processes and Policies (coding standards, Best Practices, etc.) and communicating the same with other team members.

Installed, Configured and Upgraded SQL Servers from SQL2000 to SQL2005 and also to SQL 2008, which include Clustered Servers (Both Active-Active and Active-Passive). These include both Physical and VMware servers.

Disaster Recovery Plans including Database and log backups, backup strategies (Log Shipping, Mirroring), and scheduling backups using Avamar Backup Tool.

Improved the overall Database Performance using Performance and Tuning techniques.

Created ETL Solutions and SSIS Packages to transfer the data from Production environment and Dev/QA/Staging environments.

Designed and Developed Multidimensional Databases, Data Marts and Cubes using BI techniques.

Designed and Administered Reports using SSRS.

Created and Administered Replication to synch up the data between different servers/databases.

Database Security and Users and Roles management.

Administered and managed multi server production environment.

Maintained the database health by performing regular maintenances and troubleshooting the production issues and provided 24X7 monitoring and support.

Upgraded PostgreSQL Servers from 8.3.2 to 8.4

Capacity Planning and Storage Requirement Analysis.

Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS_PROFILER.

Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.

Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.

Upgraded PostgreSQL Servers from 8.3.2 to 8.4

Monitor crontab jobs daily and rectify issues if any. Automated the dump and load of databases using korn shell scripting.

Using sp_sysmon to evaluate server level performance. Tuning configuration and server parameters.

Automated the dump and load of databases using korn shell scripting.

Designed and Implemented comprehensive solution for Release Management.

Software

Dell Power Edge Servers, SAN, & MS Cluster

Windows 2003/2000/NT, Sun Solaris, Linux and SVN

Quest (SQL Monitoring tool)

PostgreSQL 8.3.2 & 8.4

MS SQL Server 2008/2005/2000. Analysis Server 2005/2000

Sybase 12.5.3, Oracle 9i, MySQL

MOM, SOAP, SSRS, SSIS, T-SQL, PL/SQL, VB Script, PERL, XML.

ART.COM INC., RALIEGH, NC 2002 – 2009

Sr. Database Administrator, DBA Team Lead

Architected, designed and developed Databases of Corporate and e-Commerce site for Art.Com Inc, which includes regular database Architecture, Administration, Migration and Maintenance.

Key Accomplishments:

Database Modeling (Conceptual, Logical and Physical)

Designed, Implemented and Deployed the MS Cluster for Key Servers, to achieve High Availability of Servers and Databases.

Migrated/Up graded databases from SQL 7.0 to SQL 2000 and from SQL 2000 to SQL2005.

Architected database systems for merger of Art.Com and AllPosters.Com. Architected in separating the Orders database from corporate database at Art.Com as well as Allposters.com this provided the public site availability by 24X7 and independent of corporate database.

Implemented Database Growth Process and Plans to get ready for future needs.

Implemented Disaster Recovery Plans including Database and log backups, backup strategies, and scheduling backups, including system databases. Maintained the Hot Standby Back up Servers using Log Shipping. Solved database corruption issues using DBCC.

Created SSIS & DTS Packages to transfer the data between ART and APC databases.

Improved overall Performance by implementing SAN solution to database servers. Managed Disk Space and Storage Requirements and Capacity Planning.

Improved the public site SEARCH performance significantly by modifying the search algorithm, which improved the customer experience while doing searches. Also reduced the data discrepancies in read only databases by modifying business logic and jobs.

Designed and developed a Decision Support System using OLAP and data warehousing data marts and Cubes, which helped marketing department to analyze the historical data and project the Sales, Revenue, and Inventory etc. Optimized Cube Performance using Usage Based Optimization Wizard etc.

Formulated Database Coding Standards and Best Practices and oversaw that these are strictly followed by development Team. Designed and architected new databases like Sessions database, Affiliates database, Orders database etc. Created and Administered Replication (Merge & Transactional) to synch up the data between orders and corporate databases. Implemented the Referential Integrity and cleaned up database objects in all databases, which helped in reducing the data corruption and improved the data base normalization.

Database Security and Management of Users and Roles.

Designed and Developed Reports using ProClarity and Business Objects.

Administered and managed multi server production environment. Maintained the database health by performing regular maintenances and troubleshooting the production issues and 24X7 On-Call Support.

Played a Key Role in Production Deployments and Releases of all kinds of projects.

Software

Dell Power Edge Servers, SAN, RAID

Windows 2003/2000/NT and VSS

IDERA (SQL Monitoring tool)

Erwin, Visio, ProClarity, Business Objects and Crystal Reports.

MS SQL Server 2005/2000/7.0. And Analysis Server 2005/2000, MySQL

MS Cluster & Net Scalar Load Balance.

ASP, .NET, VB Script, Html, SOAP, WSDL, XML, MDX.

PEOPLE.COM CONSULTANTS INC., Pittsburgh, PA 2001 - 2002

Sr. Database Administrator

Architected and developed Enterprise IT Solution for NASDAQ (Rockville, MD), Resource Forecasting System (RFS) to enter their resource forecast information into the system by Resource and Department Managers. Also Designed and Developed Enterprise IT solution for Deloitte & Touché Consulting Inc., UFR eFiling System which is an on-line submission, tracking, and viewing of Uniform Financial Statements and supporting documentation required by Operational Services Division in Department of State, Massachusetts.

Key Accomplishments:

Database Modeling, Database Design, and other Database Objects.

Improved the database performance using Performance Tuning, Query Optimization with the help of SQL Server execution plans, SQL Server Profiler, and Index Tuning Wizard.

Achieved the bulk data transfer from flat files to database using DTS.

Developed COM+ Components using VB ActiveX DLLs and design, development of the modules using ASP, and VB Script.

Completed all deliverables on time and under budget while increasing customer satisfaction.

Software

Dell Power Edge Servers

Windows2000, IIS 5.0, Visual Source Safe

Hummingbird’s Docs Fusion, Visio

Sybase, MS SQL Server 2000/7.0

ASP, VB Script, Html, XML and Erwin

UNIQUE COMPUTING SOLUTIONS INC., Framingham, MA 1999 – 2001

Database Administrator and Team Leader

Led efforts to Architect and develop Mascot Bulldog for Mascot Networks, an online student center for colleges that offers a secure, Web-based 3 - Tier communications tool for Students and Faculty. Designed and developed an enterprise solution for computer world which provides a glimpse of where each IT vendor stands in their particular market in the eyes of those involved in purchasing IT products/services for their organizations. Managed a team of over 5 database developers and oversaw the development efforts.

Key Accomplishments:

Architected Database Development and administered the databases which include Database Modeling, Database objects, Backup and Recovery, Transactional Replication, Disaster Recovery, Full Text Search, Security, SQL Mail, Data Migration (DTS & BCP), MS-DTC.

Automated various tasks to minimize the administrative and maintenance effort and enabled a Pro-Active environment.

Developed Generalized Program to create school databases using VBScript. Tables and views have been created using XML documents.

Software

Pentium Servers and PCs

MS SQL Server 2000/7.0, Erwin

IIS 4.0, COM, COM+, MTS2.0

ASP, VB Script, Java Script, Html, XML

SONATA SOFTWARE LIMITED, Bangalore, INDIA 1998 - 1999

SQL DBA, Senior Systems Analyst and Project Leader

Designed and developed an Enterprise tool called Activity Based Tracking System, which enables managers to track, monitor and maintain software development process database for different projects. Also Architected, and Developed VB Coverage Analyzer, which aids in measuring the extent of testing done for source code written in Visual Basic. Developed a smart load tool which is used to prepare the text files that are required by data loader utility of Oracle Sales Analyzer to create a multidimensional database in Oracle Express Database.

Software

MS Win 95, SQL Server 6.5

ASP, HTML, VB Script, Java Script

Visual Basic, COM/DCOM and MTS

Oracle and Erwin

CMC LIMITED, Pune, INDIA 1996 - 1998

Sr. Engineer (Systems Integration), Team Leader

Designed and developed a system to help manage all the data involved in configuring, building, and maintaining large irrigation projects. Designed and architected a software, COMPAS (Climatological parameters Observation, Monitoring, Processing and Analysis System) is a general-purpose software product for data storage and processing of climatological (including hydrological) parameters.

EDUCATION

MS, Indian Institute of Technology (IIT), Kharagpur, India

BS, APAU, Hyderabad, India

SOFT SKILLS

Time and Priority Management

Providing Positive Feedback

Contact this candidate