Dileepkumar Nalluri
Senior Database Administrator
East Providence,RI
Summary
Highly accomplished and cloud-certified database administrator with over 12 years of extensive experience and knowledge. Demonstrated competencies in infrastructure analysis, production support, and the design and development of superior database architecture. Possessing solid expertise in database concepts, designing, backup and recovery, performance tuning, high availability setups, patching, cloning, and replication. Experienced in data migration from on-premise Oracle/Hadoop/MS SQL Server to Azure IaaS and PaaS SQL databases, as well as migrating to Aurora Postgres and Snowflake environments. Strong proficiency in setting up Snowflake and Aurora Postgres from scratch, optimizing them for performance and scalability. Skilled in handling large and complex datasets from various sources, creating complex data pipelines to migrate data from on-premise systems to Azure SQL, Azure Data Explorer, and Synapse workspace. Adept in multiple domains including retail, banking, telecom, insurance, and aviation.
Overview
12
12
years of professional experience
3
3
years of post-secondary education
4
4
Certifications
Work History
Senior Database Administrator
Geode Capital Management
1 2023 - Current
- Installed, configured, and maintained standalone SQL Servers (2016) and failover clusters for test, dev, UAT, and production environment.
- Monitored the database server performance and tuned TSQL queries, stored procedures if required.
- Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
- Created and implemented DB cutover runbooks for database migrations between two data centers.
- Setup jobs, maintenance plans for backups, rebuilding indexes, check server health, alert, notifications.
- Deployed and restored database, including Point in Time Recovery.
- Worked on ticketing tools like Jira, Zendesk, and ServiceNow to address DB-related issues and incidents.
- Managed security by defining roles and AD groups.
- Migrated databases between data centers using log shipping.
- Deployed and configured Aurora Postgres databases, optimizing settings for performance and scalability.
- Deployed and configured Aurora Postgres databases, optimizing settings for performance and scalability.
- Implemented automated backup and restore processes to ensure data integrity and recovery readiness.
- Monitored database health and performance using AWS CloudWatch and other monitoring tools to proactively address issues.
- Led data migration initiatives from on-premises systems to Aurora Postgres, ensuring seamless transitions.
- Designed and implemented Snowflake data warehouses, optimizing architecture for analytics and reporting needs.
- Managed Snowflake account configurations, including resource allocation and user roles, to ensure optimal performance.
- Developed ETL processes using Snowflake's capabilities to efficiently load and transform large datasets.
- Conducted performance tuning and query optimization, reducing query execution times significantly.
- Established automated monitoring and alerting systems to track performance metrics and identify issues proactively.
- Implemented automated backup and restore processes to ensure data integrity and recovery readiness.
Lead Consultant - Data Engineer
Concentrix Catalyst
03.2022 - 09.2022
- Working with project stakeholders to identify business needs and gather requirements for migrating data from on-premise to Azure.
- Managing team and help them to migrate on-premise SQL Server, Oracle and Hadoop systems data to Azure SQL and Postgres in Azure cloud.
- Create PySpark workbooks in Databricks to automate data migration from Oracle to Azure SQL/ PostgreSQL.
- Review and deploy Database schema creation scripts in Azure SQL and PostgreSQL.
- Create PySpark workbooks for validating data and row count post migration.
- Create Databricks workflows to push historical and incremental data from on-premise to cloud Azure SQL for all customers.
- Perform export/import of Postgres DB dumps from on-premise to Azure Postgres.
- Troubleshoot and fix Databricks workbooks failures during data migration/validation.
- Design and Implement Apache Airflow Workbooks.
- Play active role in leading team meetings and workshops with clients.
Database Analyst
Watzmann Consulting GmbH
09.2019 - 07.2021
- Experience in SQL Server Upgrade from SQL 2000 /2008/2008R2 to 2012, 2016 using side by side migration techniques on Azure.
- Involved in SQL Server DB migration from on-premises to Azure SQL, SQL Server VMs.
- Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication and Log shipping.
- Experience in Moving Data in and out of Azure SQL Databases and Blob Storage/ADX.
- Expertise in Always on and Replication setup at on-premises/cloud.
- Experience in design and administration of SSIS,SSRS and SSAS.
- Experience in PowerShell and Terraform scripting .
- Experience in migrating Data from Azure SQL to ADE using Azure Data Factory.
- Build Azure VMs through ARM templates and terraform scripts.
- Move data between IaaS and PaaS using ADF pipelines.
- Setup replication between IaaS and PaaS.
- Responsible for supporting Microsoft SQL Server database systems in Azure IaaS & PaaS(azure SQL/managed instance).
- Create private DNS for all DB servers and update Linked servers.
- Create Linked servers, IRs, Datasets and pipelines in ADF.
- Configure MMA agent to send logs to Log analytics to monitor CPU/DISK/MEMORY usage continuously..
- Configure change data capture pipelines in ADF.
- Configure, Modify NSG and ASG firewall rules through Azure Portal.
Associate Consultant
Global Logic
05.2016 - 01.2019
- Accountable for managing and supporting all Production, Development and Staging instances of SQL Server 2005/2008/2012 and 2014.
- Provide 24x7 support for critical production systems.
- Expert in installation and configuration of MS SQL Server 2014/2012/2008/2005 Databases.
- Extensive experience in Database upgrades from SQL Server 2005 to 2008, 2008 to 2012.
- Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication, Log shipping.
- Attend bi-weekly/monthly meetings to understand business needs and provide suggestions for enhancement.
- Gathering data requirements, and designing and fine tuning of databases as per the requirement of clients.
- Support L2 and L3 tickets as per the SLA.
Senior Database Administrator
Wipro Ltd
07.2014 - 04.2016
- Performed initial installation/creation of numerous Oracle and MS SQL Server databases.
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure Oracle Enterprise Manger to automate and monitor numerous DB’s.
- Involved in Data migration from SQL server to Oracle using Informatica and Export utility.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Supporting database management by utilizing upgrade, tuning and monitoring techniques.
- Utilize metalink for opening tickets, downloading and applying patches.
- Responsible for creation and management of users, roles, profiles and packages.
- Developed, tested and managed backup and recovery plans.
- Managing schema objects such as tables, views and Indexes
Database Administrator
Harman International Industries
05.2012 - 05.2014
- Administrating, troubleshooting, and debugging Oracle databases.
- Managed users, passwords and account lockouts.
- Performed Database, schema and table refresh as per requirement.
- Installed, configured and managed databases in UNIX/Linux environments.
- Monitoring alert log file on timely basis.
- Managed schemas, tablespaces and data files using Toad and SQL Developer.
- General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed.
- Managing object and system privileges, granting, revoking privileges.
Education
Master of Science - Computer Science
Periyar University
Salem, Tamil Nadu, India 06.2008 - 06.2011
Skills
MS SQL Server 2008,12,16 & 19
Oracle 10g,11g,12c &19c
Azure DB for PostgreSQL
Azure DB for MySQL
Azure SQL, MI, Azure Key Vault, Logic Apps, Automation Accounts
Azure Data Bricks, ADF, Data Lake, Synapse Analytics, ADX, Logic Apps, PySpark, Apache Spark Pools
Log shipping, Mirroring, Clustering, Always On, Replication
RAC, ASM, Dataguard, OEM, Exadata
AWS -S3, EC2, RDS, VPC & IAM
Python, Powershell
Windows Server 2008,12,16&19
Linux, RHEL and OEL
Aurora Postgres
Snowflake
Certification
AZ-104 : Azure Administrator Associate
Timeline
DP-300 : Administering Microsoft Azure SQL Solutions
10-2022
DP-900 : Azure Data Fundamentals
07-2022
Lead Consultant - Data Engineer
Concentrix Catalyst
03.2022 - 09.2022
SAA-C03 : AWS Certified Solutions Architect Associate
04-2021
AZ-104 : Azure Administrator Associate
01-2021
Database Analyst
Watzmann Consulting GmbH
09.2019 - 07.2021
Associate Consultant
Global Logic
05.2016 - 01.2019
Senior Database Administrator
Wipro Ltd
07.2014 - 04.2016
Database Administrator
Harman International Industries
05.2012 - 05.2014
Master of Science - Computer Science
Periyar University
06.2008 - 06.2011
Senior Database Administrator
Geode Capital Management
1 2023 - Current
Similar Profiles
Neelima NairNeelima Nair
Director, Software Engineering at Geode Capital ManagementDirector, Software Engineering at Geode Capital Management
SALOMBRIA THOMASSALOMBRIA THOMAS
Medical Assistant at Geode HealthMedical Assistant at Geode Health
Nieesha PrinceNieesha Prince
Licensed Clinical Social Worker/Therapist at Geode HealthLicensed Clinical Social Worker/Therapist at Geode Health