Database Administrator (START ASAP)

P&A Grant Thornton; Makati; Presencial; PHP 600 000 - 900 000; Tempo integral

Resumo da oferta

P&A Grant Thornton in Makati, Philippines, is seeking a Database Administrator to ensure IT infrastructure and databases run securely with minimal downtime. You will manage SQL Server environments, implement backups, recovery plans, and security controls while supporting applications and end users.

Responsibilities include monitoring performance, optimizing queries, documenting configurations, and collaborating with teams on new database needs.

Qualificações

• Bachelor’s degree in Information Technology, Computer Science or 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

Responsabilidades

• Monitor and proactively maintain a multi-server environment consisting of SQL Server 2005 and 2008 servers on Windows platforms
• Assist with security remediation for various business applications with a focus on database tasks
• Develop and implement improved processes for server maintenance, backups, recovery, and clustering
• Meet with internal/external teams to gather requirements for upcoming database needs
• Maintain documentation for maintenance processes and server configurations
• Assist with packaging software releases for staging/production deployments
• Support data calls and applications from database/server perspectives
• Maintain and monitor firm databases and data stores
• Prepare data backup and recovery plans for all platforms
• Conduct routine backups of server data and perform data recovery as needed
• Install and test new DBMS versions; maintain data standards and metadata
• Control access permissions and privileges

Conhecimentos

Database administration

SQL Server

Windows server

Backup and recovery

Performance tuning

Data security

Documentation

SQL scripting

SQL Server Management Studio

Formação académica

Bachelor's degree in IT/CS

Ferramentas

SQL Server Management Studio

Descrição da oferta de emprego

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