Database Administrator

Highbrow LLC; Atlanta (GA); On-site; USD 80,000 - 110,000; Full time

Job summary

A technology solutions provider in Atlanta is seeking a Database Administrator with extensive experience in RDBMS. The role involves database design, installation, maintenance, and optimization of database performance. Candidates must be proficient in SQL and experienced in data security and backup procedures. This is a long-term, on-site position offering the chance to work closely with application developers and data analysts.

Qualifications

• Extensive experience in RDBMS required.
• Proficient in SQL queries with understanding of RDBMS.
• Experience in database installation and maintenance.

Responsibilities

• Creating and optimizing database structures for efficiency.
• Implementing and maintaining backup procedures.
• Analyzing and optimizing query execution plans.

Skills

RDBMS

Database Design

Backup and Recovery

Performance Tuning

SQL

Data Security

Monitoring and Troubleshooting

User Support

OOP concepts

Tools

NumPy

Pandas

Job description

Job Title :- Database Administrator

Employment Type :- W2

Duration :- Long Term

Visa Type :- All Visa applicable which are ready for W2

Location :- Atlanta, GA (Onsite )

Job Description

• Extensive exp in RDBMS.
• Database Design: Creating database structures, defining data relationships, and optimizing database schema to efficiently store and retrieve data.
• Database Installation and Maintenance: Installing, configuring, and upgrading database software, applying patches, and managing database updates.
• Backup and Recovery: Implementing and maintaining backup procedures to ensure data can be restored in case of system failures.
• Performance Tuning: Analyzing query execution plans, optimizing database indexes, and identifying performance bottlenecks to improve database efficiency.
• Data Security: Enforcing access controls, managing user permissions, and implementing security measures to protect sensitive data from unauthorized access.
• Monitoring and Troubleshooting: Continuously monitoring database performance, identifying and resolving issues, and alerting relevant teams about potential problems.
• Capacity Planning: Forecasting future data storage needs and planning for database scaling to accommodate growing data volumes.
• Compliance Management: Ensuring database operations adhere to relevant data privacy regulations and compliance standards.
• User Support: Providing training and assistance to application developers and end-users on database access and usage.
• Collaboration: Working with application developers, data analysts, and other stakeholders to understand data requirements and integrate database solutions.
• OOP concepts. Proficient in functions and comprehensions. Knowledge on NumPy and Pandas.
• SQL: Proficient in writing SQL queries with an understanding of RDBMS