Database AdministratorP&A Grant Thornton

JOB DESCRIPTION DETAILS : The Database Administrator ensures that IT-related administrative infrastructure and systems are functioning properly, efficiently, and integrity is secured with minimal downtime; that end-users receive the appropriate levels of rights and privileges to system resources required for them to carry out their work effectively and efficiently. PRIMARY DUTIES & RESPONSIBILITIES Monitor and proactively maintain a multi-server environment consisting of SQL Server 2005 and 2008 servers on both Windows 2003 and above platforms in production, staging and laboratory environments Maintains database results by setting and enforcing standards and controls. Prepares for database expansion by studying plans and requirements; advising senior technical management; coordinating design and programming. Keeps senior technical management informed by preparing reports on system performance and problems. Upgrades hardware and software by assessing transaction processing and database production options. Maintains database performance by troubleshooting problems. Accomplishes platform upgrades and improvements by supervising system programming. Secures database by developing policies, procedures, and controls. Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations. Recommends certification and accreditation as well as security remediation for various business applications with a focus on database related tasks Develop and implement improved processes for server maintenance, back-up and recovery, fail-over and clustering Maintain documentation for maintenance processes, server configurations (both how to configure and current configurations) Maintain, administer, and monitor Firm related databases and data stores Propose improvements to directories and directory structures to facilitate ease of administration Propose, plan and implement security solutions to counter and prevent threats of all forms Prepare detailed data backup and recovery plans for all platforms Conduct routine backups of server data on all platforms Provide support and training in use of the application, including orientation for all new staff and specialized training in response to changing roles, business processes and database functionality. Work with help desk to provide technical assistance to users and troubleshoot and resolve application and database related problems (including donor, grants and financial databases). Manage the relationship with software vendors' support team, escalating issues that require immediate resolution and advocating for fixes/patches to the applications when appropriate. QUALIFICATIONS Bachelor's degree in Information Technology, Computer Science or other related fields At least one year of experience as a Database Admin on Windows platform and in administering SQL/Pervasive, Oracle, Linux/UNIX Understanding of performance monitoring tools, index and query optimization Knowledge of SQL Server architecture, such as objects, schemas, system database, SQL Services and SQL Agent Knowledge of SQL Server backup/restore and other maintenance strategies Ability to troubleshoot and solve SQL Server performance issues Experience writing SQL statements 2 to 4 years experience designing, developing and generating reports from a relational database application. Database design, deployment and management experience is highly desirable. PREFERRED QUALIFICATIONS Strong analytical and organizational skills Eye for detail and accuracy and can work independently Works well under pressure and position is on-call basis Business awareness and understanding of IT requirements
foundit

Philippines
Permanent
Full-time