SQL database administrator

Accord Technologies Inc.

Jackson, MS • Remote

$51.25 - $64/hr

Contractor

Posted 3 days ago


Job description

SQL database administrator
Jackson, MS (Remote)
Duration: 30 months
Visa : Open

 
Needed skills: Windows 10, Server OS 2008/2012,  SQL Server 2008 & Higher ,SQL, security.
 
Job Description:
  • Technically skilled database administrator with a minimum of 8+ years of experience in SQL database administration.
  • In this role, the DBA will be the respondent to database problems that arise and carry out periodic maintenance and troubleshooting.
  • Help write and optimize in-application SQL statements.
  • Ensure performance, security, and availability of databases.
  • Prepare documentations and specifications.
  • Handle common database procedures such as upgrade, backup, recovery, migration, etc.
  • Profile server resource usage and optimize and tweak as necessary.
  • Collaborate with other team members and stakeholders.
  • Responding in a timely manner to user-reported errors.
  • Protecting the database against threats or unauthorized access.
  • Ensuring that the database is adequately backed up and able to be recovered in the event of memory loss.
  • Reporting on metrics regarding usage and performance. Suggesting changes and improvements for database
  • maintenance or protection.
  • Regularly liaising with IT project managers and database programmers.
  • Designing databases with both front-end and back-end users in mind.
  • Experience with some of the modern relational databases
  • Skilled at optimizing large complicated SQL statements.
  • Knowledge of best practices when dealing with relational databases.
  • Capable of configuring popular database engines and orchestrating clusters as necessary.
  • Ability to plan resource requirements from high level specifications Capable of troubleshooting common database issues.
  • Familiar with tools that can aid with profiling server resource usage and optimizing
  • Proficient understanding of code versioning tools such as GitLab Familiar with SISS packages
  • Good verbal communication skills.
 



Frequently asked questions

Q: What skills or qualities help someone succeed as a SQL Database Administrator?

A: To succeed as a SQL Database Administrator, key technical skills include proficiency in SQL programming languages, database management systems (DBMS) such as MySQL or Microsoft SQL Server, and data modeling techniques. Additionally, soft skills like strong analytical and problem-solving abilities, effective communication, and adaptability to changing database requirements are crucial for troubleshooting, optimizing database performance, and collaborating with stakeholders. These strengths enable SQL Database Administrators to efficiently manage and maintain databases, ensuring data integrity and supporting business growth and decision-making.

Q: What is the career path for a SQL Database Administrator?

A: A SQL Database Administrator's typical career progression involves starting as a Junior Database Administrator, responsible for database maintenance and troubleshooting, then advancing to a Senior Database Administrator, overseeing database performance, security, and scalability. Along the way, they can develop skills in areas like data warehousing, business intelligence, and cloud computing, as well as obtain certifications like Oracle OCP or Microsoft MCSA. Ultimately, experienced Database Administrators can transition into leadership roles, such as Database Architect or IT Manager, or pursue specialized careers like Data Scientist or DevOps Engineer.



Accord Technologies Inc. job posting for a SQL database administrator in Jackson, MS with a salary of $51 to $64 Hourly with a map of Jackson location.