Sql Server Database Administrator
Resume:
Rambabu Paleru
Sr. SQL Server DBA
************@*****.***
Professional Summary:
Over all 11 years of experience as a SQL Server Database Administrator/Developer, with expertise in administration, design, development, and support across SQL Server environments and Snowflake.
Proficient in migrating data and optimizing performance in SQL Server, Azure SQL, and Snowflake environments.
I am skilled in developing complex T-SQL stored procedures, views, functions, and implementing Snowflake data warehousing solutions.
Manage and maintain SQL Server instances hosted on AWS (EC2, RDS), ensuring high availability, backup strategies, and performance tuning.
Administer and maintain MS SQL Server instances hosted on AWS (EC2, RDS) ensuring high availability, scalability, and performance optimization.
Installed, Configured, and Administered the HA & DR concept Always on for SQL server 2016 & 2014 instances in active-active, active-passive cluster environments.
Strong T-SQL Development skills and experience in programming complex stored procedures, Views, User defined functions, Triggers, Cursors etc.
Experienced Azure Data Bricks Developer/Administrator with expertise in big data processing, ETL, and cloud-based data solutions.
Strong knowledge of Apache Spark, Delta Lake for scalable data processing.
Hands-on experience with SQL, Azure Data Factory, Azure Synapse Analytics, and Power BI
Proficient in data transformation, ingestion, and optimization using Data Bricks Notebooks and Jobs.
Skilled in Data Governance, Security, and Compliance following industry standards.
Experience in Azure Big Data technologies
Extensively worked on SQL Server upgrades/migrated to higher SQL Versions (up to SQL 2016) and applied Service Packs and Cumulative updates.
Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
Experience in Data Modeling using MS Visio Tool.
Worked on Configuration, Implementation and Maintenance for Disaster Recovery Solutions using Log Shipping, Database Mirroring and Replication such as Transactional, Snapshot & Merge replication in SQL Server 2014/2012/2008R2.
Provisioning an Azure SQL Server and SQL Azure database through Azure web portal and Azure PowerShell
Experience in developing various Power BI reports using Visuals and Visual Properties including Tree Map, Pie Chart, Funnel, Scatter Bar Chart and Column Charts.
Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
Applied and Managed Upgrade, Migrate, Service Pack (SP), Patch Management and Hot Fixes on SQL servers (2017, 2016, 2014).
Experience in creating and maintaining Data Warehouses using SQL Server.
Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
Experienced with database sizing and capacity planning for production servers. Experienced with creating logical and physical database design for development projects.
Possess good knowledge in administering SSIS, SSRS and SSAS.
Excellent skills in database Back Up, Restore, Recovery, updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
Experience in analyzing, testing and Implementing Industry best configuration standards for huge (Databases in TB’s) and High OLTP SQL server applications.
Extensive Knowledge in SSAS storage Modes, partitions, Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
Hands on Migration of SQL server databases to Postgres SQL using DB Convert.
Basic knowledge in PowerShell scripting and automating day-to-day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.
TECHNICAL SKILLS:
Relational Databases:
SQL Server 2019/2017/2016/2014/2012, Oracle 9i/10g, PostgreSQL, Snowflake
Database Tools:
Query Execution Plan, SQL Profiler, Database Tuning Advisor (DTA), Extended Events, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio.
Languages and Data Modeling
T-SQL, DBMS, MS Visio
Operating Systems
Windows 2016, Windows 2014, Red Hat Linux
Architecture:
Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.
ETL:
SSIS/DTS, Snowflake SQL
Reporting
Power BI desktop, Power BI report server,
PROFESSIONAL EXPERIENCE:
Client: LOWES, New Jersey July 2022 - Present
Role: SQL/Azure SQL Server DBA
Responsibilities:
Worked on Azure SQL database and Azure SQL data warehouse (PaaS)
Managed integrated Data Bricks with Azure Active Directory (AAD).
Developed Power BI dashboards using Data Bricks SQL endpoints for real-time reporting.
Integrated Data Bricks with Azure Synapse Analytics for advanced analytical solutions.
Worked on Migration and SQL upgrade projects. Migrated on premise databases to the cloud (Azure)
Used Azure DevOps CI/CD pipelines for deploying Azure SQL Servers and Databases.
Worked on securing Azure SQL databases and Data warehouse in terms of Server level and database level firewalls.
Worked on troubleshooting performance and connectivity issues in Azure SQL databases
Worked on Azure Data Factory, Azure Synapse Analytics, Azure Storage Accounts, Azure Databricks for data engineering workflows
Managed Identity and Role based Access (RBAC) using Privileged Identity Management (PIM)
Worked on Setting up different V net and Subnets for different environments
Worked on Azure Database for PostgreSQL, MySQL, and Azure Cosmos Db
Implemented different auto scale down and up jobs for Cost Optimization for Azure SQL Data Warehouse.
Managed SQL Servers on Azure Virtual Machine (IaaS)
Worked on setting up High availability and Disaster Recovery solutions like Geo-replication
Planned and implemented Database Backup strategy with associated Disaster Recovery procedures according to RPO, RTO, and SLA of the company
Used Windows PowerShell and different Maintenance plans to automate tasks like updating statistics, reorganizing, and rebuilding Indexes and checking the consistency of databases
Configured Snowflake storage and computing resources to support high-performance analytics.
Developed and maintained Snowflake environments for data warehousing, including database management and tuning Snowflake queries.
Removed Security Vulnerabilities from Multiples Machines on both On Premise and Azure by consistently applying patches and hot fixes
Configured SQL Server Reporting service, developing, and publishing reports
Implemented and monitored SQL server high availability and disaster recovery solutions like Log Shipping, Mirroring, Clustering and Always on Availability Group
Evaluating CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks by using activity monitor, SQL logs, SQL Profiler & other tools
Installed and Configured SQL Server on virtual like VMware and Virtual server
Responding to requested tickets and fixing any database issues.
Working with CDC, Data Compression, and TDE
Set up baseline workloads using the SQL profiler and database tuning advisor (DTA) which resulted in providing the missing and superfluous indexing on tables.
Configured SSRS using configuration manager, created, and maintained security roles
Responsible for creating and deploying reports based on requirements using SSRS.
Used Various SSIS tasks such as Conditional Split, Derived column for Data Scrubbing
Used SSDT to extract data from multiple sources (Excel and flat files) and load into SQL Server databases and from SQL Server to Spreadsheets.
Deploy SQL scripts in production environments, applying patches, performing code review/optimize SQL for reporting, interfaces, and data conversions.
Executed Change management scripts on a daily/weekly basis.
Client: Optum Healthcare Arizona Sep 2020 - May2022
Role: SQL SERVER DBA
Responsibilities:
Performed installations, configurations, upgrades of SQL Servers and database migration.
Work in a mission critical environment in a multi-terabyte database platform.
Manage SQL Server that is running in a Hyper-V virtual machine.
Involved in installation, upgrade, configuration, and migration of SQL server in clustered and non-clustered production environments of SQL server.
Managed snapshot and transactional replication in between SQL server databases.
Installed SQL Server Reporting Services (SSRS) to create a common report template and using SSRS data source connections inside the report.
Good knowledge on Application Programming Interfaces like ODBC drivers for Teradata, JDBC drivers for Teradata, Teradata CLI.
Responsible for maintaining data integrity, including backup strategies and periodic database consistency checks.
Assists in planning, implementing, and maintaining a production MSSQL database server environment.
Setup and configured SQL Server Clustering on Window Failover Clustering Service.
Performed database builds and deployments.
Developed data-conversion processes for customization, testing, and production.
Automated and configured management tasks using PowerShell scripting language.
Wrote T-SQL queries, Stored Procedures and used them to build packages.
Configured SQL server security with business requirement such as server logins, user account and passwords along with database object permissions.
Managed complex stored procedures, functions, triggers, cursors, indexed views, tables, joins and other SQL statements.
Configured data and table partitioning on huge tables containing numerous numbers of rows for better performance.
Involved in database migration and server consolidation along with users and login.
Participated in SQL Server upgrade from SQL server 2008 to SQL Server 2012 and 2014.
Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
Ensure high availability by implementing failover clustering, Log Shipping, database mirroring or Always on Availability Group Configuration.
Configured SSIS packages to change the connection string and update the value of a variable to transform data as per Business Required Document.
Responsible for data transformation from Excel, flat file to SQL server by using BCP and data transformation services DTS utilities.
Resolve blockings, locks, and deadlocks using Activity Monitor, DMV's and SQL profiler.
Schedule and scripting DBCC commands to run daily and weekly basis to identify the health and performance of SQL server databases.
Environment: SQL Server management Studio 2008/2008R2/2012/2014/2016, Teradata, Microsoft Access, Postgres SQLV9.4 and V10, Visual Studio, T-SQL, Power Shell, SQL Server Analysis Services (SSAS), SSRS, SSIS, ServiceNow, Spotlight.
Client: Bank of America, VA Nov 2018 - Aug 2020
Role: SQL SERVER DBA
Responsibilities:
Provide database development assistance in creating specific applications for businesses.
Creating and automating the regular Jobs
Tuned and Optimized SQL Queries using Execution Plan and Profiler.
Install and upgrade SQL servers from 2005 to 2008, 2008 R2, 2012, 2014 and 2016.
Implement, maintain and document the Backup and Recovery plans of all databases.
Responsible for Scheduling Tasks, Setting Alerts, Managing Task Scheduling, setting up SQL Mail, Managing Alerts, Monitoring and Tuning SQL Server, and suggesting the scheduling strategies to overcome Blocking and Dead Locks in jobs.
Responsible for executing Data Migrations from multiple database structures using SSIS Review and Migrated Stored Procedure.
Install, create and configure Reporting Services, and Monitored Reports.
Worked more on Data Maintenance like Re-indexing, Integrity Checking and Database Shrinking.
Designed, developed, and implemented Snowflake data models to support reporting and analytics.
Managed Snowflake security roles, warehouse management, and optimized usage for cost efficiency.
Integrated Snowflake with existing data systems to support ETL workflows and data pipelines.
Responsible in preparing documentation on Disaster Recovery plan.
Monitor and tune SQL scripts, create and upgrade scripts for production databases.
Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and Database Engine Tuning Advisor.
Created and maintain the Users Security Permissions and Migration of entire database objects between multiple servers and multiple databases.
Develop database objects like Tables, Indexes, Stored procedures, Triggers, Views etc.
Configure unit test, system test, integration and regression testing of solutions.
Responsible to design, develop and implement in Snowflake.
Responsible to design, code, and implement software solutions using multiple techniques.
Automated the DBA activities for PostgreSQL and EDB Postgres Advanced Server.
Maintained and Optimized PostgreSQL, EDB Postgres Advanced Server Databases Performance through tuning.
Responsible for performance, security and availability of databases.
Worked on databases available in AWS RDS such as Aurora, MSSQL and PostgreSQL.
Created an AWS RDS Aurora DB cluster and connected to the database through an Amazon RDS Aurora DB Instance using the Amazon RDS Console.
Environment: SQL Server management Studio 2008/2008R2/2012/2014/2016, Microsoft Access, Postgres SQLV9.4 and V10, Visual Studio, T-SQL, Power Shell, SQL Server Analysis Services (SSAS), SSRS, SSIS, ServiceNow, Spotlight.
Client: Wissen Infotech, Hyderabad, India Oct 2016 – Apr 2018
Role: SQL Server DBA
Responsibilities:
Implemented High Availability in SQL 2016/2014 by configuring Always on Availability groups across Windows Server Failover Clustering using Failover Clustering Instances. Created the standard documents for Disaster recovery testing and implemented them.
Worked with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
Worked with SSIS packages in creating ad hoc reports using EXCEL and XML files, used as an ETL tool to pull data from SQL server (OLTP) to Teradata (data warehouse), maintenance tasks, providing alerts through email, Scheduling tasks and to generate scripts during migration and upgradation.
Worked in taking Backups and restoring various 3rd party tools and created Disaster recovery strategy and automated the tools to perform scheduled backups.
Upgraded server from MS SQL Server 2008R2 to MS SQL Server 2012/2014 and 2016.
Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
Created reports using SSRS from OLTP and OLAP data sources and deployed on report server. Worked extensively in performance tuning of databases including query tuning and server tuning.
Created and scheduled maintenance plans for Database backups, log backups and cleanup
As Production and development support DBA responsible for maintaining SQL Servers database servers in prod., Dev, UAT, SIT and QA Environments
Involved in implementation of Replications like Snapshot and Transactional in OLTP environments.
Migrated Databases from SQL Server 2008R2 to 2012 in Production and test Environments.
Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR.
Implemented Failover clustering for Active/Active and Active/Passive for High availability and Managed SQL Server Clusters in a SAN environment
Environment: SQL Server management Studio 2008/2008R2/2012/2014/2016, Microsoft Access, Postgres SQLV9.4 and V10, Visual Studio, T-SQL, Power Shell, SQL Server Analysis Services (SSAS), SSRS, SSIS, ServiceNow, Spotlight.
Client: Birla soft, India Aug 2014- Sep 2016
Role: SQL DBA
Responsibilities:
Involved in writing Korn shell scripts for daily RMAN backups, tape backups, Index rebuilding and to generate Multi-Master Replication. Databases are reorganized to improve performance
Developed and maintained stored procedures, functions, packages, and triggers and used Oracle standard packages. Daily monitoring Alert logs, growth of table spaces, size of the tables, top sessions and top 10 SQLs
Developed complex queries and PL/SQL procedures on Data Warehousing environment to facilitate strategic plans to higher levels of management. Created Oracle database redo log members and groups managed on-line redo log files. Responsible for Oracle database performance tuning.
Cloning of production database to the test environment using Recovery Manager (RMAN)
Database Administration and Planning including logical design, physical design, backup & recovery
Implemented Data Guard (Standby) for high availability/disaster recovery purpose
Developing a backup and recovery strategy and tested several recovery scenarios
Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.
Installation of Microsoft SQL Server and Backup Server.
Database Planning and designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions
Creation of Database Devices and Databases.
Configured, implemented, supported, and maintained physical and logical databases.
Data transfers using BCP. Granting roles and permissions to SQL server users, fixing super user permission, granting & removing permissions of all users, providing security administration by creating groups, users with appropriate roles checking the database Consistency.
Monitoring and managing the use of disk space, memory and connections, initializing database devices, Disk mirroring for recovery, creating, enlarging and removing user databases and transaction log, Creating and using segments.
Backing up and restoring databases, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash.
Client: Sonata Software, Hyderabad, India Aug 2013- Aug2014
Role: Linux & Unix Administrator
Responsibilities:
As a Linux/Unix system maintained the various servers and Production Support of various applications in Red Hat Enterprise Linux, and Windows environment.
Working in Installation, Configuration, Upgrade, Patches, and performance tuning on UNIX and system software & hardware.
Installed and configured various services like DNS, LDAP, DHCP, RPM, Send mail, Apache Web Server, Web Logic, NIS, SSH, Tomcat, Telnet, HTTP, HACMP, GPFS, SSL, NetApp, RPM Package Management, and others.
Setting up user environment according to their profiles and roles.
Assisting in basic troubleshooting of OS level issues like unexpected reboot, system down, user login problems.
Granting access to Share folders and files for individuals and groups as applicable.
System Administration tickets like adding hosts, assigning static IPs to hosts, adding aliases to hosts.
Installed packages for Ubuntu system using apt-get. Installation, configuration and troubleshooting of Microsoft Windows Servers on both physical servers and virtual machines
System administration tasks such as monitoring file system size, CPU, Memory and network performance and generation of daily system report.
Managing systems routine backup, scheduling jobs like disabling and enabling Cron jobs, enabling system logging, network logging of servers for maintenance, performance tuning, testing
Implementing Change Management like (adding & removing Disk and upgrading Hardware and software.
Troubleshooting hardware, network, and operating system related problems.
Investigating/monitoring logs on the Linux. Monitoring of web servers and other services using Nagios monitoring tool.
Environment: Linux (RHEL 5.x/6.x), Ubuntu, SSH, DNS (BIND), JIRA, Networking, Cron, Solaris 9/10/11, RedHat Satellite Server, Apache Tomcat, Nagios, Windows.
Contact this candidate