Database Administrator I

We're excited you've considered to Be More with iQor. From Customer Interactions to Product Support, we'll help you reach, stretch and realize your potential. Grow More with your own customized career path. Learn More with award-winning training. Earn More with industry-leading compensation. And Care More in a culture that treats you like family and gives back to your community. A world of opportunity is waiting. Let's get started!

Job Summary:

A Database Administrator (DBA) is responsible for managing and maintaining an organization's database systems. They ensure the performance, availability, and security of the databases, as well as troubleshoot any issues that arise. DBAs work closely with development teams, system administrators, and other stakeholders to design, implement, and optimize database systems to meet the organization's needs.

Responsibilities:

• Database Design and Implementation: Collaborate with development teams to design and implement efficient and effective database structures. This involves defining data models, tables, relationships, and constraints.
• Database Performance Tuning: Monitor and optimize database performance to ensure efficient data retrieval and processing. This includes analyzing query execution plans, indexing strategies, and database configuration settings.
• Database Security: Implement and maintain appropriate security measures to protect the organization's data. This includes defining user access controls, managing database privileges, and implementing encryption and data masking techniques.
• Database Backup and Recovery: Develop and implement backup and recovery strategies to ensure data integrity and minimize downtime in case of system failures. This involves regularly scheduling and monitoring database backups and performing recovery procedures when necessary.
• Database Monitoring and Maintenance: Continuously monitor the health and performance of the database systems, proactively identifying and resolving any issues that may arise. Perform regular maintenance tasks such as database reorganizations, index rebuilds, and statistics updates.
• Database Upgrades and Migrations: Plan and execute database upgrades and migrations to newer versions or different platforms. This includes testing and validating the upgrade process, ensuring data integrity and minimal disruption to the system.
• Documentation and Reporting: Maintain documentation related to database systems, including data models, configuration settings, and procedures. Generate reports on database performance, capacity, and availability for management and stakeholders.

Skills Requirements:

• Database Administration Skills: In-depth knowledge and experience in database administration, including database design, performance tuning, backup and recovery, security, and maintenance. Familiarity with SQL programming and scripting languages is also important.
• Problem-Solving and Troubleshooting: Strong analytical and problem-solving skills are essential for identifying and resolving database issues. DBAs should be able to analyze complex problems, propose effective solutions, and implement them in a timely manner.
• Attention to Detail: Accuracy and attention to detail are crucial for managing and manipulating large volumes of data. DBAs must ensure data integrity and accuracy through rigorous testing and validation processes.
• Communication and Collaboration: Effective communication skills are essential for collaborating with cross-functional teams, understanding requirements, and conveying technical information to non-technical stakeholders. DBAs should be able to work well in a team environment.
• Adaptability and Learning Agility: The field of database administration is constantly evolving, with new technologies and best practices emerging. DBAs should be adaptable and willing to continuously learn and upgrade their skills to stay current with industry trends.

Education Requirements:

Education and Experience: Typically, a bachelor's degree in computer science, information technology, or a related field is required. Relevant work experience as a DBA is highly desirable, including knowledge of database management systems such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL.

Physical Requirements:

Occasionally exert up to 10 lbs. of force to push, pull, lift or otherwise move objects. Have visual acuity to perform activities such as preparing and analyzing data; and/or viewing a computer terminal. Type and/or sit for extended periods of time. Consistent attendance is an essential function of the job.

iQor.com