Latest Jobs 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

go to method of application »

Educational Qualifications & Functional Skills:

• Minimum 2.1/ Upper Credit Bachelor's Degree in Computer Science, Computer Engineering, or Computer Information Systems or any related field or a combination of related experience and education.

 Work Experience:

• Hands-on experience with Perl programming, Linux, Postgres RDBMS, and Apache web server required
• Demonstrated experience developing database- driven web applications using PHP, Python, Ruby on Rails, or Java, a plus
• Previous experience with Telco OSS/BSS software. Freeside and FreeRadius, a big advantage
• Experience with software development (user experience) using JavaScript including libraries such as JQuery, Angular, React, Vue etc. XML, CSS3.0 (with dynamic, responsive web design with mobile devices), and other related UI technologies (HTML5 etc)
• Strong system integration skills
• Good understanding of web application
• development using HTTP REST, software standards, software development life cycle and methodologies
• Knowledge of software development process, quality control, and impact assessment
• Demonstrated knowledge in mobile platforms, internet technologies and user interface
• Experience working in a multi-platform (LINUX, Mac-OS and Windows) environment.
• Experience working with version control systems (Subversion, Git)