The Database Administrator is responsible for providing support, performance tuning, design and integration for Business database applications. This role will liaise with vendors and internal stakeholders throughout the application lifecycle to ensure the database is optimized, ensuring maximum application performance and availability.
Advanced MS SQL (2012 -2016) programming skills with ability to write, debug and tune procedures, functions and ETL packages.
Tune database queries for optimal performance.
Work collaboratively with system analysts and business to better understand overall business needs and make recommendations accordingly.
Partner with ICT project coordinator and interact with users to find solutions for projects and operational issues for existing and proposed databases environments.
Identify, analyze and solve problems related to database, applications or reporting in a thorough, timely manner.
Develop and document standards, policies, procedures and key performance metrics that support the continued improvement of ICT services.
Assist vendor developers with all the database activities.
Monitor application related jobs and data replication activities.
Perform code reviews and SQL code deployments.
Assist test teams in Unit and Stress testing operations.
Anticipate and devise possible solutions to application and database-related problems.
Recommend and maintain SQL Server configurations for both production and development environments.
Assist ICT team by deploying SQL Server upgrades and service packs.
Assist system admin role by performing backup, recovery and archival tasks on databases management systems.
Minimum qualification required for this position:
Bachelor's Degree preferred in Computer ScienceNote: Sufficient and relevant work experience may be considered in lieu of the educational requirements
Minimum experience required for this position:
Minimum of 5 years of experience working as a database developer/architect in a SQL Server environment.