Mainframe DB2 Database Administrator overseeing installation and administration of DB2 databases. Ensuring optimal performance, security, and robustness of the technological infrastructure.
About the role
- Manage Azure SQL and on-premises database infrastructure. Responsible for performance tuning, security, and supporting business requirements in a hybrid working environment.
Responsibilities
- Manage database infrastructure and development across Azure SQL and on-premises environments
- Balance traditional DBA responsibilities with SQL development work supporting business requirements and operational needs
- Administer and maintain Azure SQL databases and SQL Server instances (Azure VM)
- Monitor database health, performance, and security using SQL Monitor and native Azure tools
- Manage database maintenance jobs including index fragmentation, statistics updates, and backup management
- Design and implement indexing strategies with compression and appropriate fill factors
- Write and optimize T-SQL stored procedures, functions, views, and dynamic SQL
- Perform data migrations, mass updates, and data cleanup projects
- Enforce database standards: naming conventions, surrogate primary keys, audit triggers, schema design
- Manage database security using Entra ID, SQL authentication, MFA, and Azure firewall rules
- Support application developers with query optimization and database design consultation
- Archive historical data from transactional systems to maintain optimal performance
- Troubleshoot production database issues and participate in on-call rotation if needed
- Collaborate with Data Engineering team on ETL impacts from schema changes
- Participate in code reviews and maintain version control using Git and Redgate Source Control
- Assist with data engineering projects as capacity allows
Requirements
- 3+ years of SQL Server administration and T-SQL development experience
- Strong understanding of database performance tuning, indexing, and query optimization
- Experience with Azure SQL Database administration
- Proficiency with backup/recovery strategies and disaster recovery planning
- Knowledge of database security principles and implementation
- Solid T-SQL programming skills including stored procedures, triggers, and dynamic SQL
- Ability to work with business stakeholders to understand data requirements
- Experience with database monitoring and alerting tools
Benefits
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
SQL Server Database Administrator responsible for maintaining SQL database environments for WEX. Providing support for production databases, performance monitoring, and disaster recovery planning.
Senior Database Administrator complementing Engineering teams at Skyhigh Security. Designing and implementing data processing while managing cloud environments and ensuring DevOps alignment.
Database Administrator II managing Command and Control Afloat Integration Support systems for the U.S. Coast Guard in Portsmouth, VA. Role involves database administration, implementation, and data security responsibilities.
Senior Database Administrator managing and scaling databases for AI products at Plaud. Ensuring high availability, data integrity, and collaborating on data architecture strategies.
Principal Database Administrator at Epicor, guiding strategy and modernizing database platforms for Government Cloud customers. Responsible for operational stability and reliable experience for essential businesses.
Database Administrator managing SQL databases, ensuring performance and security for BCD Travel's operations. Collaborating with DevOps teams and optimizing data solutions in Monterrey, Mexico.
Senior Database Administrator overseeing database systems and migrations in Malacca. Requires 8+ years of experience and expertise in various database technologies, on - premise and cloud.
Database Administrator ensuring availability, security, integrity of MoMoPSB's database platforms that power high - volume payments. Define database strategy and execute administration to meet objectives.
Database Administrator managing, designing, and maintaining enterprise database systems at NextGen Federal Systems. Responsible for ensuring database availability, performance, and security in mission - critical applications.