SAMEER SHAIK (MS SQL DBA)
E-mail Id: ms.dba437@[Link]
Mobile Number: +91 6281182120
CAREER ABSTRACT
Hands-on experience as a MS SQL SERVER DBA with 6+ years of experience managing and optimizing large-scale production
SQL Server environments. Strong expertise in SQL performance tuning, high availability (Always On, Log Shipping, Mirroring),
backup & recovery, and 24×7 production support. growing exposure to Azure SQL. And managing large-scale databases in like
SQL SERVER DBA production support environment on windows platform. Primary focusing on DBA support and having good
knowledge in supporting different versions of SQL Server like SQL Server 2008R2 – 2022 and working on PostgreSQL and AWS
cloud instances.
EMPLOYMENT SUMMARY
Working as Lead Database administrator with Maxeon Solar Technologies, Hyderabad from JUL 2023 to Till Date.
Worked as Senior SQL DBA administrator with Alpha Networks Global Delivery Centre, Hyderabad from JUL 2022 to
JUL 2023.
Worked as Senior SQL DBA Administrator with Wipro Technologies, Mumbai from JUL 2019 to JUL 2022.
EDUCATIONAL DETAILS
Completed M.B.A (Finance & Marketing) in 2016 From JNT University.
Completed B. TECH (Computer Science Engineering) in 2012 from JNT University.
CERTIFICATIONS
Microsoft Certified SQL Server 2012 Administrator (70-462), Implementation and Maintenance.
TECHNICAL SKILLS
Operating Systems: Windows Server 2008 and 2008 R2/2012/2016/2019, Linux
Databases: SQL Server (2008 R2–2022), PostgreSQL
SQL & DBA: Query tuning, indexing, execution plans, locking/blocking
HA / DR: Always on Availability Groups, Log Shipping, Mirroring, Replication, Clustering
ETL & Reporting: Knowledge in SSIS, SSRS
Cloud (Azure & AWS): AWS, Azure SQL, Azure Data Factory
Tools: SSMS, DMV’s, DBCC, DTA, Profiler, Commvault, Druva Backup, Veeam Backup
PROFESSIONAL SUMMARY
Expertise in Installing, configuring, securing and managing SQL servers to ensure better performance and applica-
tion availability.
Exposure to SQL Server and Windows environments.
Experience in working with production (24 x 7) and development environments.
Instrumental in High Availability tasks of SQL Server such as Backup, Restore, Replication, Log shipping, Mirror
server, always on, cluster and Security.
Able to configure jobs for routine activities and troubleshooting them in case of failures.
Familiar with implementation strategies, backup/recovery strategies.
Monitor SQL Server down, SQL Server Agent, Error log, Application and System logs, Job failures, Backup Fail-
ures, Database and Log growth, CPU, Memory and Disk Utilization using the in-house built SQL Server monitoring
tool.
Creating database users, controlling access to SQL Server and making sure right people get access to right data and
looking after the security issues.
Experienced in advanced concepts of SQL server like Mirroring and log shipping.
Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
Expertise in implementing MS SQL Server security and database permissions.
Performing the Failover and Failback operations in the cluster environment and adding the new Disks and
troubleshooting activities.
Troubleshooting Space issues and performing Capacity Planning for Production Database servers.
Database performance monitoring and tuning when required as per application and business requirements.
Performing Database Refresh from Production to Stage environment.
Experience with upgrades from SQL Server from 2008 R2 to 2012 and 2012 to 2014 till 2022
Experience in SQL Server migration activities
Working on Windows and SQL Server clustering
Configured Automation Alerts like Long Running Queries and Error Logs Reports Blockings on Prod Environ-
ment.
Working on PostgreSQL related Backup and restore and clear the storage to remove the Archive backups in Postgr-
eSQL
Knowledge on Veeam Backup replication tool related and configured backup jobs.
Having knowledge in Linux related.
Knowledge on AWS RDS instances and Azure SQL Management and EC2 and S3 Storage related.
Flexibility working in 24*7 environment
Administrating MS SQL Server, analytical, monitoring, troubleshooting, organizational skills, and assessment planning
and implementation.
Team player, willing to share and develop my knowledge and experience
Ability to handle multiple tasks and tight deadlines.
Working with different clients has made me interact with people of different cultures and mind-sets.
PROJECT DETAILS
PROJECT 3
Client: Maxeon Solar Technologies, Singapore.
Role : Lead Database Engineer
SQL Version’s : Microsoft SQL Server [Link] Server 2012R2/2016/2019.
Tools : SSMS, DTA, DBCC and DMV’s,
Duration : JULY 2023 to Till Date
Roles & Responsibilities:
• Managing 100+ production databases (5TB+ total size) in 24x7 enterprise environments.
• Administering Azure SQL and AWS EC2-hosted SQL Server & PostgreSQL instances.
• Designed Always on AG architecture reducing downtime by 60%.
• Performed on-prem to Azure/AWS migrations with zero data loss.
• Optimized EBS storage volumes and improved I/O performance by 30%.
• Improved query performance by 35–40% through advanced tuning techniques.
• Implemented automated monitoring and alerting reducing incident resolution time by 30%.
• Managing PostgreSQL Backups related
• Managing AWS RDS migration from on-premises to AWS RDS instances
• Managing Cloud storage S3 and Azure Data factory.
PROJECT 2
Client: Maxeon Solar Technologies, Singapore.
Role : Senior Database Administrator
SQL Version’s : Microsoft SQL Server 2014/2016/2017/[Link] Server 2012R2/2016.
Tools : SSMS, DTA, DBCC and DMV’s
Duration : JULY 2022 to JULY 2023
Roles & Responsibilities:
• Managed SQL clusters, Log Shipping, and Mirroring for enterprise applications.
• Reduced blocking and deadlocks by 50% through proactive monitoring.
• Executed version upgrades and cross-platform migrations.
• Maintained backup & recovery strategies ensuring RPO < 15 mins.
PROJECT 1
Client: IDFC FIRST BANK LIMITED.
Role : Associate MSSQL Database Administrator
SQL Version’s : Microsoft SQL Server 2008R2/2012/2014/2016/[Link] Server 2012R2/2008R2/2016.
Tools : SSMS, Profiler, DTA, DBCC and DMV’s
Duration : JULY 2019 to July 2022
Roles & Responsibilities:
• Supported high-transaction banking databases processing millions of records daily.
• Maintained 99.99% uptime in mission-critical financial systems.
• Implemented DR drills and failover testing ensuring business continuity.
• Handled patching, security audits, and compliance requirements.