Senior Database Administrator

P&A Grant Thornton; Makati; On-site; PHP 250,000 - 420,000; Full time

Job summary

P&A Grant Thornton is seeking a Database Administrator to ensure IT infrastructure and database systems run efficiently with minimal downtime. The role focuses on managing SQL Server environments, applying performance optimizations, and implementing security controls across production, staging, and lab environments.

The candidate should have a Bachelor’s degree in IT/CS and at least 1 year of relevant Windows-based database admin experience, with knowledge of SQL Server architecture and

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.
• 2 to 4 years experience designing, developing and generating reports from a relational database application.

Responsibilities

• Monitor and proactively maintain a multi-server SQL Server environment in production, staging and lab environments.
• Maintain database performance by troubleshooting problems and applying fixes.
• Develop and implement improved server maintenance, backup/recovery, failover and clustering processes.
• Secure databases by developing policies, procedures, and controls.
• Provide support and training on database functionality to staff and assist help desk.

Skills

Strong analytical skills

Organizational skills

Attention to detail

Independent work

Works well under pressure

Education

Bachelor's degree in IT / CS

Job description

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
• 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