Data Sql

Nikhil Bondugula

Email: ***********@*****.***

Linkedin www.linkedin.com/in/nikhil-reddy-bondugula

Phone: 917-***-****

Professional Summary:

• Over 8 years of strong experience in the IT industry as an expert in the design, development, implementation and administration of database systems using MS SQL Server, MongoDB, RDS PG-SQL, DynamoDB, Redshift, snowflake for both transactional & Data Warehousing Environments.

• Designed ETL architecture for overall data transfer across SQL-Server, Oracle & MongoDB

• Highly proficient in the use of T-SQL, PL/SQL, PG-SQL for developing and debugging complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing

• Expert in developing & resolving (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.

• Experience of working with developers, analyst, project managers & programmers in building, deploying & supporting numerous applications.

• Experience in working at agile environment & with the ability to run products (In-House built & vendor hosted) makes me an expert.

• Design and Implemented enterprise grade MongoDB solution using Red Hat 7.1 and Mongo 3.0.10 version. Taking advantage of Sharding, Replica Set, new storage engine WiredTiger and Ops Manger.

• Implemented ELK (Elastice Logstach Kibana) for reading Mongod Logs to understanding DB usage and Maint Activates and performance tuning

• Experienced in generating reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.

• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).

• Extensive experience in Database activities like Data Modeling, Database design, development, database creation and maintenance, performance monitoring and tuning, and troubleshooting.

• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication in VM ware environment also.

Technical Skills:

Databases

MS SQL Server 2000/2005/2008/2008R2/2012/2014/2016/2017/2019, Oracle 10g/11i, MS Access PGSQL, MongoDB, RDS

ETL tools

Specialized in Microsoft Visual Studio, SSIS, SSAS, SSRS, Export & Import, DTS, Informatic, Datavers, AWS Glue

Operating System

Windows 2000, 2003, 2012r2 server,2012 server,2008r2 server,2008 server 2016, 2019, Linux

Software Tools

Visual Studio 2005, Visual Source safe, Microsoft Visio, MS Excel, Win Runner 7.5, VM ware tool, Load Runner 7.0, Macromedia Flash 2004and MS SharePoint designer

Languages

Mongo, JSon, C, ASP.NET, VB.NET, XML, PowerShell, T-SQL, PL/SQL, PG-SQL.

Other Tools & application

Other skill include Eilte ENterprise,Imanage worksite,Caprdiem time Entries,Heat Ticketing system, workday, peoplesoft, whitehill, My SQL, DB2,, Microsoft SharePoint, Agile/Scrum, SQL YOG, Dreamweaver, JavaScript, SCcM knowledge, XML, HTML, Linux, Unix,,PHP, SSH, Word press,

Professional Experience:

FM Systems Nov 2019 - Present

Raleigh, NC

Senior Database Administrator/Engineer

Managing SQL instance on AWS EC2 and RDS Supporting 600 clients across globe

Working on a project of to standardize the Application Databases hosted in client Local DC

Designing solution for AWS Datawarehouse solution (POC Redshift, Data lake, Glue, FSX, ELK)

Working on octopus CI\CD pipeline implementation of code deployment

Streamline day to day operational task to reduce alerts

Created custom monitoring alerts and Optimized code for better performance

Implemented massive DB level changes to stabilize the environment and sustain long-term

Provide leadership and mentoring to members of Agile development team

Established best practice guidelines for code quality, test coverage, and documentation

Moved legacy codebase and build process to Github

Provide technical insight to product management team

Established best practice guidelines for code quality, test coverage, and documentation

Provided architectural guidance for large scale data ingestion from IoT sensor hardware

Drove design of reporting data warehouse across multiple product lines

Developed enhanced reporting dashboard for environmental data captured from IoT sensor hardware

Fresenius Medical Care-NA Oct 2016– Nov 2019

Lexington, MA

Senior Database Administrator

• Technical Sr. SQL Server and MongoDB Database Administrator currently supporting 190+ SQL engines and 55 MongoDB instances.

• Managing a total of 150+ TB of data across 5 data centers.

• Leading the effort to reduce off-hour pager alerts by 50%. Finding root cause for each pager alerts and designing permanent solution.

• Designing solution using new features in SQL Server 2014 while migrating old instances.

• Design and Implemented enterprise grade MongoDB solution using Red Hat 7.1 and Mongo 3.0.10 version. Taking advantage of Sharding, Replica Set, new storage engine WiredTiger and Ops Manger.

• Supporting world’s largest and heavily customized implementation of Siemens’s signature product Soarian financials and clinicals doing an average of 25,000 batches/sec with sustained peak of 50,000 batches/sec.

• Sr DBA for upgrade from version 3.4 to 4.2 from end to end with post deployment support. Worked closely with Siemens DBA team which resulting a flawless deployment.

• Streamline non-production database refresh and cut down turnover time by 50%.

• Created SSRS dashboard from scratch to give a status snapshot of application, database, replication etc… Dashboard is being used by operations, product and DBA team daily.

• Optimized native backup with optimal setting resulting 40% reduction in backup time.

• Implemented database backup directly to data domain saving 20tb of SAN space in 5 datacenter.

• Successful storage migration from 3 par to EMC VMAX in conjunction with storage virtualization VPLEX.

• Designed and Supported AWS hosted RDS PgSQL Environment for their daily ETL schedules and Reporting task.

• Supporting MongoDB and upgraded to 3.4.12 and now in path to 4.0

Employer Name: Apex Technology System Dec 2013- Mar 2016

South Plainfield, New Jersey

Client Name: Fresenius Medical Care-NA, Lexington, MA

Client Name: Debevoise & Plimpton LLP, New York City, NY

Role: Database Administrator and Systems support.

Environment: MS SQL Server 2005, 2008.2008 R2, 2012, 2014, MongoDB, VM ware, windows 2008, 2008 R2, 2012, 2012 R2

Responsibilities:

• Support DBA for upgrade from version 3.3 to 3.4 from end to end with post deployment support. Worked closely with Siemens DBA team which resulting a flawless deployment.

• Build a 40TB Replication Environment with trigger and constraints for ETL DW extracts,

• Work on moving from native to NetBackup (veritas)

• Added new Health Check to SSRS dashboard from scratch to give a status snapshot of SQL Instances. Dashboard is being used by Entire DBA team on a daily basis.

• Supported in implementing database backup directly to data domain saving 20tb of SAN space in 3 datacenters.

• Designed an intelligent Custom update statics concept and index rebuild – reorg balancer

• Provided necessary documentation and shared them across the team using SharePoint Tool.

• Installed SQL Server 2014/2012/2008 R2 on Windows Clustered and standalone environments with latest service packs.

• Experience in working and troubleshooting 2TB Very Large databases (VLDB) in OLTP Environment.

• Developed custom reports to monitor the product usage & Custom reports for data analyzing during migrations

• Daily routine Developer/ DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs. Reduced database size and increased performance.

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

• 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.

• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.

• Reorg/Rebuilding the indexes at regular intervals for better performance. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

• Analyzing server performance and performing root cause analysis using native and third-party tools.

• Involved in User Acceptance Testing, debugging of the system and taking data objects across different data stages namely Development, Test and Production.

Cultivait Software Technologies Ltd Mar 2012 – July 2013

London, U.K

Role: System Administrator / Production Support Tier/level-3

Environment: Server 2012, 2008 R2, 2008, 2005, SSIS, SSRS, SQL Safe, SQL, Linux

Responsibilities:

• Provide Production Support and give 24/7 on-call support

• Involved in the DB Migration process from one Data Center to another data center.

• Installed and Configure SQL 2012,SQL 2008 R2, SQL 2008 Active/Active and Active/Passive Cluster on production servers.

• Day-to-day Technical Support on MS SQL Server 2012/ 2008 R2/2005 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered).

• Implement code changes and configuration changes (if needed) and other administrative activities.

• Writing of O/S Shell and Oracle scripts for automation and monitoring of databases.

• Work in cooperation with developers/team for achievement of efficient database access for applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL changes to application development teams.

• To ensure all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft Servers in Production, Dev and QA Environment.

• Setting up Transactional and snapshot Replication for Production Environment.

• Running various DBCC commands for administration of database objects and system performance.

Educational Details:

Master in Communication Engineering Aug 2010 – Nov 2011

Bachelors in Electronic & communication engineering Oct 2005 – April 2009

Contact this candidate