SATEESH MOGALAPU (DBA)

ad353l@r.postjobfree.com +1-248-***-**** Redmond, WA

Summary:

With 9 years of expertise as a SQL DBA and Azure Cloud Administrator.

Hands-on expertise in Azure Operations, covering IAAS and PASS Infrastructure.

MS SQL DBA Activities: Capacity planning, performance tuning, disaster recovery, and 24x7 production services.

Successful migration of On-Perm SQL to Azure Cloud Services (IAAS, PAAS).

Installation and configuration of various MS SQL Server versions in Windows environments.

Specialization in Disaster Recovery with technologies like Always On, Clustering, and Log Shipping.

Proficient in creating Azure Pipelines, configuring SSIS packages, and managing Linked Services.

Experienced with PostgreSQL DB and skilled in configuring and optimizing Azure Cosmos DB.

Built the instances on AWS, EC2 machines, Azure Blob containers & feature pack components.

Experience in designing and deploying AWS Solutions using EC2, S3, and Elastic Load balancer (ELB), auto-scaling groups.

Working knowledge of networking concepts, routing, rules, DNS, ingress, and load balancing.

Skilled in configuring Linked Servers between SQL Server & Oracle and troubleshooting.

Managed production databases across multiple MSSQL versions, including 2008, 2012, 2014, 2016, and 2019. Technical Skills:

Cloud Technologies: Azure IAAS, Azure SQL, Data Lake, AWS, EC2, RDS.

Databases: SQL SERVER 2019/2016/14/12, MS-Access 2016/07/03, PostgreSQL

ETL Tools: MDS, SSIS, EDM.

Reporting: PowerBI, NANOBI, SSRS, MS excel

Languages: T-SQL, HTML,Power shell.

Web servers: Apache Tomcat, IIS 5.0/6.0/7.0

Operating systems: Unix, Linux, Windows Servers 2000/2003/2008 R2/2012, Win8/7/10

Tools and Utilities: SQL Safe, Solar Winds,SCCM, SCOM, SCSM, Service Now, PowerShell, GitHub, Remedy, Salesforce, JIRA.

Experience/Responsibilities:

DIGI TECH LABS SQL Server DBA Mar ‘2023 - Present Client: T-Mobile

Roles & Responsibilities:

As a Lead Database Administrator, I was responsible for the following:

Creating Azure VMs (IAAS) using Azure Portal and PowerShell and install SQL Server as per the requirements.

Performing monitoring, analysis & troubleshooting in production systems running on Azure cloud stack

Assisting with performance tuning, performance optimization and query optimization for MSSQL/Azure SQL databases

Setting up and maintaining auditing for MSSQL and Azure SQL servers and databases. Analyze and implement security & performance best practices.

Designing and developing appropriate data models and structures to support data analytics initiatives.

Collaborating and assisting Azure DevOps team in production with incident and change management, regularly supported production online sprint/release deployments. Covered 24/7 on-call duty on the project, during non- business hours only.

Developing and maintaining ETL processes to extract data from source systems, transform it as required, and load it into the data warehouse, ensuring timely and efficient data migrations and submissions.

Providing end-to-end Azure SQL Database support, including deployment, configuration, and monitoring of Azure resources.

Lead and execute the successful migration of on-premises SQL Server databases to Azure Cloud Services, encompassing both Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) offerings. Trans Neuron Technologies Pvt Ltd SQL Server DBA Aug ‘2020 to Feb ‘2023 Client: Government of India

Roles & Responsibilities:

As a Senior Database Administrator:

Identified, defined, and assessed properties for the database management system (DBMS) aligned with organizational needs, creating a logical structure based on company organization.

Executed procedures for testing and implementing new applications, implementing policies for data security, and monitoring access policies.

Maintained corporate data libraries, ensuring project and department milestones were met on time and within budget.

Specialize in implementing robust disaster recovery solutions utilizing technologies such as Always On, Clustering, and Log Shipping, ensuring high availability and data protection.

Design and deploy AWS solutions, leveraging key services like EC2, S3, Elastic Load Balancer (ELB), and auto-scaling groups to create scalable and resilient architectures.

Installed, configured, and maintained PostgreSQL database systems, managing backup and recovery strategies for data integrity.

Provided Level 3 support for high-volume, business-critical production applications, including Azure SQL Databases.

Implemented and managed Azure Security Center policies, actively participating in incident management and root cause analysis.

Appright Software Solutions Pvt. Ltd SQL Server DBA Feb ‘2016 to Jul‘2020 Client: TATA

Roles & Responsibilities:

As a Senior Database Administrator, I was responsible for the following:

Administered MS SQL Server, overseeing user logins, daily backups, and database health checks.

Collaborated with the Development team on database and application deployment issues.

Installed, configured, and maintained Microsoft SQL Server 2012 & 2014 instances.

Conducted performance monitoring, query analysis, and implemented optimization plans.

Ensured data security and integrity through access controls, encryption, and regular audits. Appright Software Solutions Pvt. Ltd SQL Server DBA Dec ‘2014 to Jan ‘2016 Client: Vanguard Group, Inc.

Roles & Responsibilities:

As a Database Administrator, I was responsible for the following:

Installation & Administration of SQL Server 2012.

Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to user and groups.

Database backup checks on daily basis.

Creating maintenance plan for performing Optimizations and fine Tuning of DB Application.

Recovering the database from backup in case of disaster.

Creating jobs and alerts for monthly and weekly maintenance.

Moving system and user databases across drives as per requirement.

Monitoring and troubleshooting Log shipping issues and ensuring primary and Standby.

Worked on Mirroring implemented databases and traverse its proper functionality.

Contact this candidate