ProTrans

Database Administrator

• Provide technical leadership on database systems and solutions and act as the final technical escalation point for database-related issues
• Manage, maintain, implement, and support Microsoft SQL Server databases in cloud-hosted high-availability environments using Always-On Availability Groups, mirroring, and replication
• Plan and execute SQL Server upgrades, migrations, and lifecycle management initiatives
• Perform capacity planning, storage forecasting, and resource utilization analysis
• Conduct research, analysis, monitoring, and profiling to improve database performance, functionality, recoverability, and availability
• Ensure data integrity, quality, and security across database systems
• Participate in disaster recovery planning and testing; manage and validate backup, restore, and recovery strategies
• Architect and maintain databases for optimal performance and scalability
• Manage database maintenance activities, including index optimization, statistics maintenance, and SQL Agent job management
• Deploy and maintain database security controls and support security initiatives and audits
• Cross-train peers and provide guidance on complex database issues
• Refine, automate, and document DBA processes through diagrams, SOPs, and scripts
• Manage and tune database monitoring systems
• Participate in an on-call rotation supporting business-critical systems
• Participate in development code reviews and educate teams on SQL coding standards and best practices
• Collaborate with developers, BI, management, and IT staff to ensure reliability and solve complex data challenges
• Evaluate, test, and recommend new technologies and tools

Senior Database Administrator

• Provide technical leadership on database systems and solutions and act as the final technical escalation point for database-related issues
• Manage, maintain, implement, and support Microsoft SQL Server databases in a cloud-hosted high-availability environment using SQL on VMs, Always-On Availability Groups, mirroring, and replication
• Plan and execute SQL Server upgrades, migrations, and lifecycle management initiatives
• Perform database capacity planning, storage forecasting, and resource utilization analysis
• Conduct research, analysis, monitoring, and profiling to improve database performance, functionality, recoverability, and availability
• Ensure data integrity, quality, and security across database systems
• Participate in disaster recovery planning and testing; manage and validate backup, restore, and recovery strategies
• Perform regular recovery testing for business-critical databases
• Architect and maintain databases for optimal performance and scalability
• Manage database maintenance, including index optimization, statistics maintenance, and SQL Agent job management
• Deploy and maintain database security controls and support security initiatives and audits
• Cross-train peers and team members and provide guidance on complex database issues
• Establish database standards and best practices while refining, automating, and documenting DBA processes through diagrams, SOPs, and scripts
• Manage and tune database monitoring systems
• Participate in an on-call rotation supporting business-critical systems
• Participate in development code reviews to promote SQL coding standards and best practices
• Collaborate with developers, BI, management, and IT staff to ensure database reliability and performance and solve complex data challenges
• Evaluate, test, and recommend new technologies and tools