SQL Server Database Administrator responsible for maintaining SQL database environments for WEX. Providing support for production databases, performance monitoring, and disaster recovery planning.
About the role
- Database Administrator managing SQL Server installations, backups, performance tuning, and security. Collaborating with stakeholders to meet database requirements.
Responsibilities
- Database Installation and Configuration: Configuring SQL Server software on servers post Installation and ensuring proper configuration settings for optimal performance and security.
- Database Maintenance: Performing regular backups, restoration, and recovery of databases to ensure data integrity and minimize downtime in case of failures.
- Database Monitoring and Performance Tuning: Monitoring the performance of databases, identifying and resolving performance issues, optimizing queries, and fine-tuning server configurations to ensure efficient and smooth operation.
- Security and Access Management: Implementing security measures such as user authentication, authorization, and auditing to protect sensitive data. Managing user access, roles, and permissions within the database.
- Database Troubleshooting: Investigating and resolving database-related issues, such as connectivity problems, data corruption, and performance bottlenecks. Applying patches and fixes to address bugs and vulnerabilities.
- Database Documentation: Maintaining accurate and up-to-date documentation of database configurations, procedures, and troubleshooting guides to ensure easy reference for future tasks and knowledge sharing.
- Database Capacity Planning: Monitoring database growth and resource utilization to anticipate and plan for future storage requirements and performance enhancements. Making recommendations for hardware upgrades or additional resources as needed.
- Disaster Recovery Planning: Developing and implementing disaster recovery strategies and procedures to ensure business continuity in case of system failures or disasters. Testing and validating backup and recovery processes regularly.
- Collaboration and Communication: Collaborating with application developers, system administrators, and other stakeholders to understand and address their database requirements and concerns. Communicating effectively to provide timely updates and resolutions.
- Continuous Learning: Keeping up-to-date with the latest SQL Server features, best practices, and industry trends. Participating in training programs, attending conferences, and exploring relevant resources to enhance your skills and knowledge.
Requirements
- 5 years of database related experience required
- High school diploma or equivalent required. Bachelor’s degree in Computer Science, Computer Information Systems, Management Information Systems, or a directly related field.
- A certification in databases management would be appropriate
- Good analytical and problem-solving skills.
- Ability to demonstrate understanding of SQL Database Management System application's architecture, data structures, and functionality.
- Proficient in SQL database engine administration, setup and maintenance of user and group security.
- PowerShell and T-SQL Scripting: Learn PowerShell scripting to automate administrative tasks in SQL Server. Also, have a strong understanding of T-SQL (Transact-SQL) scripting language to write complex queries, stored procedures, and functions.
- SQL Server Upgrades and Migrations: Understand the process of upgrading SQL Server to newer versions and migrating databases to new servers. Familiarize yourself with the associated risks and best practices.
- Best Practices and Industry Standards: Stay updated with the latest best practices, industry standards, and security guidelines for SQL Server. Follow Microsoft's official documentation and online resources to ensure you're using recommended practices.
- Good written and verbal communication skills. Ability to communicate technical info and ideas so others will understand.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
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.
Senior DBA managing Snowflake cloud platform at Honeywell, focusing on database administration and strategic innovations. Collaborating on data management initiatives in a hybrid work environment.