Database Administrator at Conclase Consulting

Description

• The Database Administrator’s role is to design, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability.
• This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Responsibilities 

Strategy & Planning

• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures. 
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Operational Management 

• Create models for new database development and/or changes to existing ones.
• Data extraction, transformation, and loading into databases. 
• Install and configure relevant network components to ensure database access as well as database consistency and integrity.
• Respond to and resolve database access and performance issues.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements. 
• Monitor, optimize and allocate physical data storage for database systems. 
• Plan and coordinate data migrations between systems. 
• Database’s performance monitoring. 
• Database object documentation.
• Develop, implement, and maintain change control and testing processes for modifications to databases. 
• Create, or support creation of, required reports in response to business user needs.
• Perform database transaction and security audits.
• Establish appropriate end-user database access control levels. 
• Develop routines for end users to facilitate best practices database use. 
• Manage and/or provide guidance to junior members of the team. .

Formal Education & Certification 

• College diploma or university degree in the field of computer science, information systems, or computer engineering with relevant years of work experience. 
• Certifications in Microsoft BI Stack or SQL Server (Optional).

Knowledge & Experience 

• Strong understanding of database structures, theories, principles, and practices. 
• Working technical experience with designing, building, installing, configuring, and supporting database servers, including MySQL, SQL Server 2008 to 2019
• Hands-on database tuning and troubleshooting experience. 
• Familiarity with in-house data-intensive applications, including SFA, ERP (Navision & Business Central), HRSS etc. Experience with data processing flowcharting techniques.
• Project management experience. 
• Knowledge of applicable data privacy practices and laws