- Mon Dec 15, 2025 1:21 am#11951
PREPARATION GUIDE FOR THE POSITION OF SENIOR DATABASE ADMINISTRATOR
DOHATEC NEW MEDIA – DHAKA
1. UNDERSTAND THE ROLE
• The primary responsibility is to ensure continuous, high‑performance operation of the e‑GP database environment.
• Key functions include configuration, monitoring, performance tuning, backup/restore, disaster‑recovery, clustering, log‑shipping, and providing support to development and network teams.
• You will also be expected to produce technical documentation, train colleagues, and handle incident resolution within SLA limits.
2. MATCH YOUR PROFILE TO THE REQUIREMENTS
– Age ≥ 32 years
– Bachelor of Engineering (or equivalent)
– 10–12 years of DBA experience, preferably in a software‑company setting
– Hands‑on expertise with Microsoft SQL Server (multiple versions) including installation, configuration, clustering (Always On), log‑shipping, backup/restore, and performance tuning.
– Experience with SAN storage, OS clustering, and DR concepts (RPO/RTO).
– Strong SQL scripting, documentation, and ability to design/maintain data dictionaries.
If any of these items are missing, plan a focused catch‑up before the interview.
3. TECHNICAL SKILL BUILD‑UP
A. SQL SERVER CORE
• Install and configure a full‑stack SQL Server environment (Express, Standard, and Enterprise editions) on virtual machines.
• Practice creating databases, tables, indexes, stored procedures, functions, and triggers.
• Master T‑SQL: complex joins, window functions, CTEs, dynamic SQL, error handling, and transaction control.
B. HIGH‑AVAILABILITY & DISASTER RECOVERY
• Set up an Always On Availability Group with at least four nodes (two primary, two secondary). Test failover, read‑only routing, and replica synchronization.
• Configure and validate Log Shipping between primary and secondary servers.
• Implement Database Mirroring (if still supported) for comparison.
• Create scripts for automated backup, restore, and point‑in‑time recovery; verify RPO/RTO targets.
C. PERFORMANCE TUNING & MONITORING
• Use Microsoft tools: Database Engine Tuning Advisor, Query Store, Profiler, Extended Events, DMVs, and Performance Dashboard.
• Identify and resolve blocking, deadlocks, and expensive queries.
• Practice index design: clustered, non‑clustered, filtered, columnstore, and covering indexes.
• Learn resource governor configuration and monitor CPU, memory, I/O, and tempdb usage.
D. STORAGE & SAN KNOWLEDGE
• Study SAN concepts: LUN provisioning, tiering, RAID levels, and snapshot technologies.
• Understand how to map SAN LUNs to SQL Server data, log, and tempdb files for optimal I/O distribution.
E. OS CLUSTERING & FAILOVER
• Set up Windows Server Failover Cluster (WSFC) basics, add SQL Server as a clustered resource, and test node failures.
F. SCRIPTING & AUTOMATION
• Develop PowerShell scripts for routine tasks: backups, health checks, index maintenance, and alerting.
• Create PowerShell DSC or Ansible playbooks for repeatable SQL Server deployments.
G. DOCUMENTATION & METADATA MANAGEMENT
• Write a sample data dictionary entry for a few tables, including column definitions, constraints, and business rules.
• Draft standard operating procedures (SOPs) for backup, restore, patching, and performance review.
H. SECURITY & COMPLIANCE
• Implement role‑based access control (RBAC) and least‑privilege principles.
• Configure Transparent Data Encryption (TDE) and Always Encrypted where applicable.
• Practice auditing and log review using SQL Server Audit.
4. CERTIFICATIONS (OPTIONAL BUT VALUABLE)
– Microsoft Certified: Azure Database Administrator Associate (if cloud exposure is relevant)
– Microsoft Certified: Data Analyst Associate (for data‑management credibility)
– Vendor‑neutral: Certified Information Systems Security Professional (CISSP) or Certified Disaster Recovery Engineer (CDRE) for DR knowledge
5. REAL‑WORLD PRACTICE PROJECTS
• Migrate a sample production database (e.g., AdventureWorks) from an on‑premises SQL Server to an Always On Availability Group.
• Simulate a DR scenario: trigger a failover, perform log‑shipping restore, and verify data consistency.
• Design and implement a full backup strategy (full + differential + transaction log) and test point‑in‑time restores.
6. SOFT‑SKILLS & INTERPERSONAL PREPARATION
– Prepare to explain complex technical concepts to non‑technical stakeholders (e.g., “What is RPO and why does it matter?”).
– Develop a concise incident‑management story: how you resolved a critical database outage within SLA.
– Be ready to discuss teamwork: collaborating with developers for schema changes, with network engineers for latency issues, and with security teams for access reviews.
7. RESUME & APPLICATION TUNING
• Highlight 10–12 years of DBA experience, emphasizing projects that involve Always On, clustering, log‑shipping, and performance tuning.
• List specific versions of SQL Server you have administered (e.g., 2008 R2, 2012, 2016, 2019, 2022).
• Include measurable achievements: “Reduced average query response time by 35 % through index redesign” or “Implemented DR solution achieving 15‑minute RTO”.
• Add any relevant certifications, training sessions conducted, and documentation authored.
8. INTERVIEW PREPARATION
Technical Questions to Anticipate
– Explain the difference between Always On Availability Groups and traditional failover clustering.
– How do you calculate and set appropriate RPO and RTO for a critical database?
– Describe the steps to troubleshoot a long‑running blocking scenario.
– What are the benefits and trade‑offs of using columnstore indexes versus traditional rowstore indexes?
– Walk through the process of setting up Log Shipping and how you monitor its health.
Scenario‑Based Questions
– “Your primary replica goes down unexpectedly. What actions do you take to ensure minimal downtime?”
– “A developer requests a large schema change that may impact performance. How do you assess and mitigate risk?”
Behavioral Questions
– “Tell us about a time you led a knowledge‑transfer session for junior DBAs.”
– “Describe a situation where you had to balance competing SLA priorities.”
Preparation Tips
• Prepare STAR (Situation, Task, Action, Result) stories for each key competency.
• Review the company’s e‑GP product line and think about data‑flow implications.
• Be ready to discuss how you stay current with SQL Server releases and Microsoft best practices.
9. APPLICATION LOGISTICS
– Submit your application through the online portal before the deadline (Dec 25 2025).
– Attach a tailored resume, a cover letter that references Dohatec’s focus on e‑GP and digital security, and any supporting documents (certificates, project summaries).
– Ensure your contact details (phone, email) are up to date; the recruiter may schedule a rapid initial screening.
10. POST‑APPLICATION FOLLOW‑UP
• Send a brief thank‑you email within 24 hours of any interview, reiterating your fit for the role and enthusiasm for contributing to Dohatec’s mission.
• If you haven’t heard back after two weeks, consider a polite follow‑up to demonstrate continued interest.
By systematically addressing each of the areas above—technical mastery, documentation, incident handling, and communication—you will be well‑prepared to meet the expectations of the Senior Database Administrator role at Dohatec New Media. Good luck!
DOHATEC NEW MEDIA – DHAKA
1. UNDERSTAND THE ROLE
• The primary responsibility is to ensure continuous, high‑performance operation of the e‑GP database environment.
• Key functions include configuration, monitoring, performance tuning, backup/restore, disaster‑recovery, clustering, log‑shipping, and providing support to development and network teams.
• You will also be expected to produce technical documentation, train colleagues, and handle incident resolution within SLA limits.
2. MATCH YOUR PROFILE TO THE REQUIREMENTS
– Age ≥ 32 years
– Bachelor of Engineering (or equivalent)
– 10–12 years of DBA experience, preferably in a software‑company setting
– Hands‑on expertise with Microsoft SQL Server (multiple versions) including installation, configuration, clustering (Always On), log‑shipping, backup/restore, and performance tuning.
– Experience with SAN storage, OS clustering, and DR concepts (RPO/RTO).
– Strong SQL scripting, documentation, and ability to design/maintain data dictionaries.
If any of these items are missing, plan a focused catch‑up before the interview.
3. TECHNICAL SKILL BUILD‑UP
A. SQL SERVER CORE
• Install and configure a full‑stack SQL Server environment (Express, Standard, and Enterprise editions) on virtual machines.
• Practice creating databases, tables, indexes, stored procedures, functions, and triggers.
• Master T‑SQL: complex joins, window functions, CTEs, dynamic SQL, error handling, and transaction control.
B. HIGH‑AVAILABILITY & DISASTER RECOVERY
• Set up an Always On Availability Group with at least four nodes (two primary, two secondary). Test failover, read‑only routing, and replica synchronization.
• Configure and validate Log Shipping between primary and secondary servers.
• Implement Database Mirroring (if still supported) for comparison.
• Create scripts for automated backup, restore, and point‑in‑time recovery; verify RPO/RTO targets.
C. PERFORMANCE TUNING & MONITORING
• Use Microsoft tools: Database Engine Tuning Advisor, Query Store, Profiler, Extended Events, DMVs, and Performance Dashboard.
• Identify and resolve blocking, deadlocks, and expensive queries.
• Practice index design: clustered, non‑clustered, filtered, columnstore, and covering indexes.
• Learn resource governor configuration and monitor CPU, memory, I/O, and tempdb usage.
D. STORAGE & SAN KNOWLEDGE
• Study SAN concepts: LUN provisioning, tiering, RAID levels, and snapshot technologies.
• Understand how to map SAN LUNs to SQL Server data, log, and tempdb files for optimal I/O distribution.
E. OS CLUSTERING & FAILOVER
• Set up Windows Server Failover Cluster (WSFC) basics, add SQL Server as a clustered resource, and test node failures.
F. SCRIPTING & AUTOMATION
• Develop PowerShell scripts for routine tasks: backups, health checks, index maintenance, and alerting.
• Create PowerShell DSC or Ansible playbooks for repeatable SQL Server deployments.
G. DOCUMENTATION & METADATA MANAGEMENT
• Write a sample data dictionary entry for a few tables, including column definitions, constraints, and business rules.
• Draft standard operating procedures (SOPs) for backup, restore, patching, and performance review.
H. SECURITY & COMPLIANCE
• Implement role‑based access control (RBAC) and least‑privilege principles.
• Configure Transparent Data Encryption (TDE) and Always Encrypted where applicable.
• Practice auditing and log review using SQL Server Audit.
4. CERTIFICATIONS (OPTIONAL BUT VALUABLE)
– Microsoft Certified: Azure Database Administrator Associate (if cloud exposure is relevant)
– Microsoft Certified: Data Analyst Associate (for data‑management credibility)
– Vendor‑neutral: Certified Information Systems Security Professional (CISSP) or Certified Disaster Recovery Engineer (CDRE) for DR knowledge
5. REAL‑WORLD PRACTICE PROJECTS
• Migrate a sample production database (e.g., AdventureWorks) from an on‑premises SQL Server to an Always On Availability Group.
• Simulate a DR scenario: trigger a failover, perform log‑shipping restore, and verify data consistency.
• Design and implement a full backup strategy (full + differential + transaction log) and test point‑in‑time restores.
6. SOFT‑SKILLS & INTERPERSONAL PREPARATION
– Prepare to explain complex technical concepts to non‑technical stakeholders (e.g., “What is RPO and why does it matter?”).
– Develop a concise incident‑management story: how you resolved a critical database outage within SLA.
– Be ready to discuss teamwork: collaborating with developers for schema changes, with network engineers for latency issues, and with security teams for access reviews.
7. RESUME & APPLICATION TUNING
• Highlight 10–12 years of DBA experience, emphasizing projects that involve Always On, clustering, log‑shipping, and performance tuning.
• List specific versions of SQL Server you have administered (e.g., 2008 R2, 2012, 2016, 2019, 2022).
• Include measurable achievements: “Reduced average query response time by 35 % through index redesign” or “Implemented DR solution achieving 15‑minute RTO”.
• Add any relevant certifications, training sessions conducted, and documentation authored.
8. INTERVIEW PREPARATION
Technical Questions to Anticipate
– Explain the difference between Always On Availability Groups and traditional failover clustering.
– How do you calculate and set appropriate RPO and RTO for a critical database?
– Describe the steps to troubleshoot a long‑running blocking scenario.
– What are the benefits and trade‑offs of using columnstore indexes versus traditional rowstore indexes?
– Walk through the process of setting up Log Shipping and how you monitor its health.
Scenario‑Based Questions
– “Your primary replica goes down unexpectedly. What actions do you take to ensure minimal downtime?”
– “A developer requests a large schema change that may impact performance. How do you assess and mitigate risk?”
Behavioral Questions
– “Tell us about a time you led a knowledge‑transfer session for junior DBAs.”
– “Describe a situation where you had to balance competing SLA priorities.”
Preparation Tips
• Prepare STAR (Situation, Task, Action, Result) stories for each key competency.
• Review the company’s e‑GP product line and think about data‑flow implications.
• Be ready to discuss how you stay current with SQL Server releases and Microsoft best practices.
9. APPLICATION LOGISTICS
– Submit your application through the online portal before the deadline (Dec 25 2025).
– Attach a tailored resume, a cover letter that references Dohatec’s focus on e‑GP and digital security, and any supporting documents (certificates, project summaries).
– Ensure your contact details (phone, email) are up to date; the recruiter may schedule a rapid initial screening.
10. POST‑APPLICATION FOLLOW‑UP
• Send a brief thank‑you email within 24 hours of any interview, reiterating your fit for the role and enthusiasm for contributing to Dohatec’s mission.
• If you haven’t heard back after two weeks, consider a polite follow‑up to demonstrate continued interest.
By systematically addressing each of the areas above—technical mastery, documentation, incident handling, and communication—you will be well‑prepared to meet the expectations of the Senior Database Administrator role at Dohatec New Media. Good luck!
