Uppuluri

About Uppuluri

• 14 years of experience in IT Services and Operations with expertise in SQL Database Administration and Database Application Developer in a global 24x7 OLTP environment. • Supported over 160 database servers of low to high complexity in Production, UAT, Test and Dev environments. Maintained multiple servers and 30 TB of databases. • Experienced in Installation, Configuration, Maintenance, and Administration of SQL Server 2017,2016,2014,2012,2008R2/2008/2005/2000/7.0 in standalone and clustered environments. Configured more than 2 GB RAM for 32-bit and 64-bit systems using AWE switches. • Experienced in migration of SQL Server from version 2000,2005/2008/2008R2 to 2012/2014/2016/2017 and Upgradation. Handful of Experience on SQL server new features like Microsoft SQL multi server administration, resource governor, performance data collector. • Experienced in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures. • Experience of configuration and working with Microsoft SQL server 2008/2008R2/2012/2014/2016/2017 on VMware Environment. Experience in Migrating DTS 2000 packages to SSIS packages in 2005/2008R2/2012/2014/2016/2017 using Migration Wizard. Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active and Active Passive) and Database Mirroring. • Worked with Tivoli Data Protection (TDP) and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008R2/2012/2014/2016/2017. • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services. • Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting. • Expertise on physical storage SAN configuration on different RAID levels. • Excellent in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions. • Hands on experience with administering large databases, managed databases of size above 3 terabytes, database design, normalization and database application development using varied development tools. • Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning. • Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2. • Experience in trouble shooting sql server jobs, and job monitoring tool. • Worked with Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery. • Auditing of database for user’s transaction, login and database action and removing and fixing orphan users. • Expertise in using DBCC trace flags, handling blocking and dead lock situations. • Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMVs, Index Tuning Wizard and Windows Performance Monitor, Foglight. • Experience in creating Packages, Jobs, sending alerts using Database mail, SQL Mail and custom extended procedures. • Creation and maintenance of Databases, Roles and managing user permissions. • Experience in Troubleshooting and documenting root cause analysis. • Closely worked with development team to assist them in various problems solving, troubleshooting Web-based applications. • Worked with Third party tools like Litespeed, Fog light and Red gate, Tivoli Storage Manager (TSM). • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. • Checking the threshold values and baselines and monitoring in perfmon and SCOM. • Rebuilding indexes with different fill factors and updating statistics. • Experience in Database Security and Management. • Experience in Security Patches & Hot fixes installation and management (schedule-coordinate-install) • Experienced in performing various SQL Server 2000 & 2005, 2008R2, 2012, 2014, 2016, 2017 High Availability activities like Installation, Configuring and Maintaining SQL Clustered Servers (Active/Active & Active/Passive), Network load balanced servers, working with transactional Replication, Log Shipping and Database Mirroring. • Created maintenance plans to perform Index De-Fragmentation, Re-Indexing and update the Index Statistics. • Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, SSRS, DTS, BCP, BULK INSERT etc. • Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages. • Good experience on resolving database performance issues and monitoring the growth of the database to ensure the smooth running of daily activities. • Worked extensively on monitoring the databases, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases in response to the Tivoli Alerting System. • Experience in strong SQL debugging skills, application level troubleshooting skills, experience with monitoring tools and techniques, good understanding of security practices. • Experience in successfully resolving SQL Server problems within SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, backup/restore, database corruption, security etc • Experience in using tools like SQL Profiler and Performance counters for Monitoring, Fog light, Performance Analyzer and Tuning MS SQL Server Performance. • Experience in working with Windows Server 2000/2003/2008/2012/2016. • Experienced in creating/maintaining automation Scripts with SQL. • Hands on experience in trouble shooting deadlock issues, performance issues, data archival on every three months, rebuilding indexes. • Experienced in ITIL process (Change Management, Release Management, Problem Management, and Incident Management) and IT Infrastructure, Networking, and RAID environment. • Experienced in query optimization, DMVs, Maintenance Plans, and Upgrades. • Experienced in database designing, Normalization, VB.NET, C#, ASP.NET. • Assisted and supported customers, developers, QA’s in database related issues. • Experienced scheduling all the alerts in database server using MOM, Tivoli, Maximo, Control-M, SQL default alerting system, Foglight. • Experienced in writing SQL queries, stored procedures, functions, triggers. • Upgrading to SQL Server 2008R2/2012/2014/2016/2017. • Experienced with MSBI SSIS, SSRS, SSAS, PowerBI installation, troubleshooting, upgrade • Experienced with SOX/PCI compliance. • Experience with AWS migration & operations support. • Experienced SQL Server Standards and Hardening. • Deploying, managing, and operating scalable, highly available, and fault tolerant servers on AWS. • Migrating an existing on-premises application to AWS. • Implementing and controlling the flow of data to and from AWS. • Installed, Configured, Worked with Foglight for SQLServer tool. • Experienced with DB2 and Oracle versions. • Mongo DBA, • Working on Amazon Web services. • Experienced with SSAS cubes migration from 2000, 2005/2008/2008R2 to 2012/2014/2016/2017. • Worked with migrating analysis services databases and as SSAS DBA. • Experienced with E-Commerce, IBM DB2/LUW, Linux, Oracle and Erwin. • Creating and monitoring Azure SQL Server databases. • Migrated databases from on-premises to Azure. • Configured and Maintained Elastic DB pools. • Working with Geo Replication. • Configuring backups and restoring databases from recovery vault. • Experienced in CPU, Disk, DTU usage alerts and Monitoring for Azure SQL servers. • Configuring Server level and database auditing for SQL server. • Select the correct tier for Azure SQL Databases. • Experience in working with Performance Metrics and Plan Management. • Working with applications running on Amazon EC2 in AWS. • Self-motivated person with strong analytical, problem solving and communication skills. Capable of working under pressure and a good team player who can be flexible and work individually. • Worked with MySQL, AZURE RDS, performance tuning, backup/recovery, and scalability/capacity planning, SQL, PL/SQL, and UNIX shell scripting, IT troubleshooting/problem-solving experience. • Oracle Database Administration experience with administering and supporting multiple • Oracle databases on UNIX/Linux platform • Experienced in systems integration, software development, message-based middleware and SOA, APIs, API management, data modelling, legacy integration techniques, DB staging tables and stored procedures • Experienced in Azure Stream Analytics, consists of an input, query, and an output. • Worked with Stream Analytics ingests data from Azure Event Hubs, Azure IoT Hub, or Azu, DB2 DB. • Experienced as Database Application Developer • Worked in Healthcare, Banking Domains. • Experienced on core AWS services, uses, basic architecture and best practices • Good Knowledge in Aurora databases, AWS RDS, Postgres, AWS DMS • Able to write, debug and optimize complex PostgreSQL queries • Experienced in managing AWS Aurora upgrades to higher versions • Good understanding of performance optimization/Tuning on Aurora SQL Scripts, views and procedures • Experienced creating roles, database access, performing vacuum operations • Experienced in managing point-in-time restore • Working with HADOOP • Worked with Power Shell • Worked with Red Hat Linux, Sybase DBA, IMS. • Worked with Active Directory Services. • Mainframe Technologies (COBOL, CICS, DB2 and VSAM)