Database Administrator

POSITION GENERAL DUTIES AND TASKS : RESPONSIBILITY • Responsible for maintaining, modifying, updating, and providing quality assurance and performance-tuning for database, according to software specifications, IT protocols, and established business rules. • Ensures that data integrity issues are identified and proactively addressed. • Builds and maintains strong, trusting relationships with non-technical users, as well as with technical coworkers in software development roles, in identifying database performance gaps and emerging opportunities, and addressing user needs and issues. • Design and develop advanced database solutions including T-SQL stored procedures and triggers. • Monitor and maintain security and performance needs of relational databases. • Monitor long running transactions and have the ability to optimize query executions with index tuning and optimized T-SQL coding techniques. • Write database documentation including data standards, procedures, and definitions for a data dictionary. • Develop, manage, maintain and test backup and recovery plans. • Capacity Planning. • Communicate regularly with technical, applications and operational staff to ensure database integrity and security. EXPERIENCE • This position requires at least five years of experience developing relational database applications with a primary focus on complex SQL joins; three years of experience creating scripts in a development environment, testing scripts in a quality assurance environment and implementing large data updates into production databases. • Experience on Configuration and managing databases such as MySQL, DB2, MSSQL, Postgesql.