What are the responsibilities and job description for the Database Administrator position at Security National Mortgage Company?
Description
The Database Administrator (DBA) is responsible for the performance, integrity, security, and availability of enterprise databases across the organization. Approximately 60% of this role is dedicated to database administration, development, and optimization, primarily within Microsoft SQL Server environments. The remaining 40% involves close collaboration with the Network team to support infrastructure-level initiatives, ensure database connectivity and availability, and assist with system-level troubleshooting. This is a highly collaborative, hands-on position suited for a technical professional who thrives in a dynamic, large-scale enterprise environment.
Requirements
Database Administration (approximately 60%)
• Install, configure, upgrade, and maintain Microsoft SQL Server instances across development, test, and production environments.
• Monitor database performance using SQL Server tools (SQL Profiler, DMVs, Query Store) and proactively resolve bottlenecks.
• Design, implement, and manage database backup, recovery, and disaster recovery strategies to ensure business continuity.
• Develop and enforce database security policies including user roles, permissions, and auditing.
• Create and optimize stored procedures, views, indexes, and queries to support application and reporting needs.
• Perform routine database maintenance tasks including index rebuilding, statistics updates, and integrity checks.
• Manage database capacity planning and growth projections; recommend infrastructure changes as needed.
• Support ETL processes and data integration efforts across enterprise systems.
• Document database architectures, processes, configurations, and change management activities.
• Participate in on-call rotation for after-hours database support as required.
Network & Infrastructure Collaboration (approximately 40%)
• Work alongside the Network team to ensure stable and secure connectivity between application servers and database instances.
• Assist with network-level troubleshooting that impacts database performance or availability (latency, DNS, firewall rules, load balancers).
• Support the deployment, configuration, and maintenance of virtual and physical servers hosting database services.
• Collaborate on infrastructure projects including server migrations, hardware refreshes, and data center initiatives.
• Participate in capacity planning discussions to align database and network infrastructure roadmaps.
• Contribute to IT security initiatives, including patch management, vulnerability assessments, and compliance requirements.