database technician.
oak ridge , tennessee
posted today
job detailssummary
$30 - $35 per hour
temp to perm
associate degree
category computer and mathematical occupations
reference1044937
job detailsjob summary:We are seeking an experienced and detail-oriented Database Technician to join our team and play a crucial role in managing and optimizing our extensive portfolio of SQL databases. You will be responsible for database installation, configuration, performance tuning, security management, and overall maintenance. Additionally, they will collaborate with developers and data architects to design efficient database structures that align with the organization's needs. The role requires a deep understanding of SQL queries and the ability to troubleshoot and resolve database-related issues efficiently. The position is vital in ensuring the integrity, availability, and security of our databases, particularly those supporting critical services such as Cayenta.location: Oak Ridge, Tennesseejob type: Contractsalary: $30 - 35 per hourwork hours: 8am to 4pmeducation: Associatesresponsibilities:Database Installation and Configuration:
Install and configure database management systems, including Oracle, MySQL, Microsoft SQL Server, or PostgreSQL.
Performance Tuning:
Monitor and optimize database performance by identifying and resolving bottlenecks, optimizing queries, and adjusting system parameters.
Backup and Recovery:
Implement and manage backup and recovery procedures to ensure data integrity and availability in case of system failures or data corruption.
Security Management:
Implement security measures to protect databases from unauthorized access, ensure compliance with data protection regulations, and manage user access privileges.
Data Maintenance:
Manage data quality, data cleansing, and data archiving to ensure the efficiency and effectiveness of databases over time.
Capacity Planning:
Estimate future storage and resource requirements, planning for database growth accordingly.
Patch Management:
Apply patches and updates to DBMS and associated software to address security vulnerabilities and improve performance.
Database Design:
Collaborate with developers and data architects to design efficient database schemas and structures.
Monitoring and Alerts:
Set up monitoring tools and alerts to proactively identify and address issues such as performance degradation or disk space shortages.
Documentation:
Maintain detailed documentation of database configurations, procedures, and troubleshooting steps for reference and auditing purposes.
Disaster Recovery Planning:
Develop and test disaster recovery plans to ensure business continuity in the event of a catastrophic failure.
Automation:
Implement automation scripts and tools to streamline routine maintenance tasks and improve efficiency.
Troubleshooting:
Investigate and resolve database-related issues, such as data inconsistencies, query problems, or system failures.
Database Upgrades:
Plan and execute database software upgrades while minimizing downtime and ensuring compatibility with existing applications.
Compliance:
Ensure that databases and related processes comply with industry-specific regulations and standards, such as GDPR, HIPAA, or PCI DSS.
Training and Support:
Provide training and support to end-users and team members on database-related topics and best practices.
Performance Analysis:
Analyze database performance trends and propose improvements or enhancements to meet business objectives.
The role requires strong SQL expertise, attention to detail, and the ability to work in a dynamic environment where interpreting complex databases is critical for maintaining and enhancing city services.qualifications:
Experience level: Experienced
Minimum 2 years of experience
Education: Associates
skills:
SQL
SQL Server
HelpdeskEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected] offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).Applications accepted on ongoing basis until filled.