Junior Database Administrator

P&A Grant Thornton; Makati; On-site; PHP 400,000 - 640,000; Full time

Job summary

P&A Grant Thornton in Makati seeks a Database Administrator to ensure multi-server SQL environments operate securely with minimal downtime. You will manage backups, recovery, security, and performance while collaborating with internal teams to meet database needs.

The role requires a bachelor's in IT/CS and at least one year of SQL/Pervasive/Oracle on Windows, with strong SQL skills and documentation discipline. On-site position with standard business hours.

Qualifications

• Bachelor’s degree in Information Technology, Computer Science or related field.
• At least 1 year of experience as a Database Admin on Windows platform and in administering SQL/Pervasive, Oracle, Linux/UNIX.
• Understanding of performance monitoring tools and index/query optimization.
• Knowledge of SQL Server architecture, such as objects, schemas, system databases, 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.

Responsibilities

• Monitor and proactively maintain a multi-server environment consisting of SQL Server 2005/2008 in production, staging, and lab environments.
• Assist with certification/accreditation and security remediation for database tasks.
• Develop and implement improved processes for server maintenance, back-up and recovery, fail-over and clustering.
• Meet with internal and external teams to gather requirements for upcoming database needs, testing and monitoring.
• Maintain documentation for maintenance processes and server configurations.
• Assist with packaging software releases for deployment to staging and production.
• Support data calls and applications from database and application server perspectives.
• Uphold incident reporting, time accountability, versioning, naming conventions, etc.
• Maintain, administer, and monitor Firm databases and data stores.
• Propose security improvements and data directory enhancements.
• Prepare detailed data backup and recovery plans for all platforms.
• Conduct routine backups of server data and perform data recovery when required.
• Perform other tasks as directed by superiors.
• Map out conceptual database design and translate to a data model; install/test new DBMS versions; enforce data standards and access privileges

Skills

Performance monitoring

Index & query optimization

SQL troubleshooting

SQL statements

Education

Bachelor’s degree in IT or CS

Tools

SQL Server

Pervasive

Oracle

Linux/UNIX

Job description

The Database Administrator ensures that IT-related administrative infrastructure and systems are functioning properly, efficiently, and securely 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
• Assist with 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
• Meet with both internal and external teams to gather requirements for upcoming database needs, implementation of those requirements, testing and monitoring for specific functional and performance targets
• Maintain documentation for maintenance processes, server configurations (both how to configure and current configurations)
• Assist with packaging software releases for deployment to staging and production for both vendor and custom-developed systems
• Support data calls and specific applications as needed from both the database and application server standpoint
• Actively participate and uphold required business processes and standards such as incident reporting, time accountability, versioning, naming conventions, etc. as needed
• 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
• Perform recovery of data when required
• Perform any other tasks deemed necessary by superiors
• Mapping out the conceptual design for a planned database and refining the logical design so that it can be translated into a specific data model;
• Installing and testing new versions of the DBMS; maintaining data standards, including adherence to the local regulations; writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata); controlling access permissions and privileges

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

PREFERRED QUALIFICATIONS

• Strong analytical and organizational skills
• Eye for detail and accuracy
• Works well under pressure and position is on-call basis
• Business awareness and understanding of IT requirements