Key Responsibilities :
Implement, document and maintain the database design including physical and logical data models.
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.
Participate in On-Call rotation for critical production support.
Perform all routine scheduled SQL Server and database maintenance.
Qualifications and Personal Characteristics :
Skills necessary to achieve minimum competency standards :
Possess a solid understanding of the relationships of architecture components within technology infrastructure.
Expertise with the following technologies : MS SQL 2012-2016
Experience working with .Net, C# technologies.
Knowledge and experience working with source code version control systems.
Excellent Data Modeling experience.
Strong understanding of coding methods and best practices.
MCDBA or MCSA database development certification.
Familiarity with BI and analytics techniques a plus.
Excellent communication skills a must.
Ability to provide support and participate in an on-call rotation
Experience with DR and BCP
Minimum qualification required for this position :
Bachelor's Degree preferred in Computer Science
Note : 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.
Minimum of 3 years of experience working as a database administrator.
Minimum of 3 years of experience working with large, complex databases in a medium-large enterprise environment.
Añadir a los favoritos
Eliminar de mis favoritos
Debes iniciar sesión en tu cuenta para agregar este empleo a tus favoritos. Haz clic en "Continuar" para acceder a tu cuenta o crear una cuenta nueva. Luego de iniciar sesión, podrás ver y organizar tus favoritos tanto en nuestro sitio web como en la aplicación móvil.