Sql Server Database Administrator

Shyam Dama

SQL Server Database Administrator

Mobile: +1-423-***-****

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

Professional Summary

Highly skilled and detail-oriented SQL Developer and Database Administrator (DBA) with over 7 plus years of experience in managing and maintaining Microsoft SQL Server environments in production, development, and testing, particularly within standalone server settings. Their expertise encompasses the entire SQL Server lifecycle, from installations to migrations, and cloud-based solutions, as well as a strong foundation in Transact-SQL and database design

Extensive experience in administering and maintaining MS SQL Server across various versions (2019/2017/2016/2014/2012/2008R2/2008/20), including installations, upgrades, and troubleshooting technical issues.

A comprehensive understanding of the software development life cycle (SDLC) and project methodologies, including tools and techniques used in each phase (data dictionaries, programming languages, technical platforms, standards, and procedures

Proven ability in migrating SQL Server databases from older versions to newer ones (e.g., 2000 to 2005, 2005/2008/2008R2 to 2012/2014/2016/2019), and in analyzing and migrating in-premise databases to the cloud using Azure data migration assistant.

Proficient in utilizing PowerShell scripts for various tasks, such as backing up and restoring databases, changing passwords, migrating SSRS reports, and migrating SQL Server logins, linked servers, jobs, and alerts.

In-depth knowledge of Transact-SQL (DDL, DML, DCL), including database design and normalization, and hands-on experience in creating triggers, tables, user functions, views, stored procedures, indexes, user profiles, relational database models, data dictionaries, and data integrity.

Experience in developing alerts, reports, and automated processes for failed jobs, as well as automating common tasks like backup failure notifications, user disabling, password changes, audit collection, and database promotions.

Proven ability in managing security in all versions of SQL Server databases by creating database users, roles, and assigning proper permissions.

Knowledge in extracting, transforming and loading data (ETL) using SSIS, DTS, Import/Export Data, Bulk Insert, BCP.

• Designing and developing the data marts and developed SSIS packages to load data into those data marts.

• Experience in designing and developing machine critical reports using SQL Server Reporting Services.

• Experience in analyzing transactional data and developing dimensions and cubes using SQL Server Analysis services and building reports against cubes.

• Experience in writing MDX queries to extract data form SSAS cubes.

• Excellent Documentation Skills.

• Experience in providing 24X7 On-Call Support for analyzing and fixing the production issues.

• Self-motivated individual with strong analytical skills and ability to meet challenging deadlines in a fast paced work environment.

• Fast learner with ability to work independently or with a team on multiple projects at one time.

Technical skills:

SQL Development: T-SQL scripting, modular & reusable code, stored procedures, triggers, views, functions, Dynamic SQL, set-based logic, error handling, transactions, cursors when needed.

ETL & Reporting: ETL pipelines using SSIS from Excel, flat files, APIs, and RDBMS, SSRS for custom and ad-hoc reports: parameterized, drill-down, drill-through reports, SSAS OLAP and Tabular Models: MDX/DAX queries, KPIs, hierarchies, cubes.

Database Administration: Installation, upgrades, backups/restores, high availability (mirroring, log shipping, replication), Security: user roles, TDE, auditing, Monitoring & performance tuning (Profiler, Execution Plans, DTA), Capacity planning and patch management.

Tools & Technologies: SQL Server (2005–2019), SSIS, SSRS, SSAS, SSMS, SQL Profiler, Power BI, Tableau, Metabase, Git, Hadoop, Hive, Azure, Cloudera, DuckDb, Teradata, Apache Spark.

Programming Languages: SQL, C, C++, Java.

Databases: SQL Server, MySQL, MS Access, Dynamic DB, MongoDB, Timescale DB, Foundation DB.

Operating Systems: Windows Server (2000–2016), Linux.

Certifications

Microsoft Certified: Azure Database Administrator Associate

Microsoft Certified: Azure Data Fundamentals

Education:

Bachelors in Computer Science and Engineering

Professional Experience

Client: Bank Of America, Texas

Role: SQL Server Database Administrator

Duration: July 2024 – Present

Responsibilities:

Involve ensuring high performance, availability, and security of SQL Server environments, including managing backups, restores, and disaster recovery. DBAs also assist developers

Creating, managing, and maintaining multiple databases, including schema management, user permissions, and security configurations and Collaborating with developers to optimize queries, indexes, and database configurations to ensure optimal performance

Developing and implementing backup and recovery strategies, ensuring data integrity and availability during outages

Implementing and managing high availability solutions like Always On Availability Groups and planning disaster recovery procedures

Implementing and maintaining security measures, including encryption, access control, and compliance with data protection regulations

Manage, promote and maintain the SQL Server Integration services (SSIS) packages on production servers.

• Manage, promote and maintain the SQL Server Reporting services (SSRS) Reports on production servers.

• Manage, promote and maintain the SQL Server Analysis services (SSAS) databases and cubes on production servers.

• Review, and promote all database changes by application developers into acceptance and production environment using appropriate tools

• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.

• Involved in resolving dead lock issues and performance issues

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Monitored networks database performance with scripts.

• Created groups, roles, users and assigned access privileges to users.

• Interacted with Development team to assist in writing T-SQL queries, stored procedures and database triggers.

• Used native tools like Data Base Tuning Advisor, Profiler and Activity Monitor for performance analysis.

• Provided 24X7 on call support for all the production and development databases.

Environment:

Sql server 2019/2022,SSRS,SSMS(2022),SSIS,SSAS, Windows server 2022/2025

Client: Cigna,florida

Role: SQL Server Database Administrator

Duration: Aug 2022- June 2024

Responsibilities:

Responsible for mission critical production support issues and serve as a primary database technical contact, and work closely with end users, project managers, and application developers to ensure successful delivery of projects

• Responsible for the RDBMS Installation, Daily monitoring, maintenance of SQL server 2008/2008R2/2012/2014/2016/2017/2019 in the Development, Acceptance, Performance Volume stress (PVS) and Production environments as per standards.

• Review capacity and configurations and make changes as needed

• Review long running queries and tune them by working with application development teams.

• Define, manage, and monitor Backup Strategies and recovery policies and procedures.

• Monitoring and troubleshooting the problems with reference from alert and event logs.

• Monitoring networks database performance with tools and scripts.

• Implementing and monitoring SQL server database High Availability techniques like Database Mirroring, Replication, Clustering, and Always on Availability Groups.

• Define, create, manage, and monitor Backup Strategies and recovery policies and procedures using Dell EMC DD Boost and SQL Safe.

• Automate DBA routine tasks using PowerShell scripts.

• Implemented drift management using PowerShell scripts for the tasks like fixing orphan users, synchronize logins between availability groups and synchronize SQL Server jobs between Always availability groups, database ownership and SQL Server jobs ownership, and mismatched settings between availability group nodes.

• Provided 24X7 on call support for all the production databases

Environment:

SQL Server 2022(16.X),SSMS 19.0,SSRS,SSAS,SSIS,Windows server 2022

Client: Tech Buzz, Hyderabad, India

Role: SQL Developer

Duration: Sep 2018 -July 2022

Responsibilities:

Designing and implementing database structures, including tables, views, stored procedures, and functions.

Writing and optimizing SQL queries to improve performance and efficiency.

Performing routine maintenance tasks like backups, restores, and index management.

mplementing and managing database security, including user access controls and encryption.

Diagnosing and resolving database errors and performance issues.

Creating and maintaining documentation for database structures, procedures, and queries

Identifying and resolving performance bottlenecks, including optimizing query execution plans and data storage

Designing and implementing data migration and extraction, transformation, and loading (ETL) processes.

Designing and implementing database architectures, including choosing appropriate database platforms and technologies.

Reviewing code written by other developers to ensure quality and adherence to best practices.

Mentoring junior developers and providing training on SQL programming and database design.

Collaborating with other teams, including business analysts, database administrators, and application developers

Leading database projects and contributing to the overall database strategy.

Conducting security audits of databases and systems to ensure compliance with industry standards.

Analyzing data and generating reports to support business decisions.

Environment: SQL Server 2016/2017, SSMS, SSIS, SSRS, Windows Server 2016, Git, Visual Studio

Environment:

Sql server 2016/2017/2019,SSIS,SSRS,SSMS,SSAS, Windows server 2019

Contact this candidate