Senior Database Developer

Start your adventure in the wonderful world of MicroSourcing by signing up now.

Search Jobs

Senior Database Developer

• IT & Telecomms
• DBA / Database Developer
• Libis, Quezon City
• Permanent / Full Time

5/6/2024

Position Title:
Senior Database Developer

Department/Campaign:
Information Technology

Position Location:
MDC Bldg. Philippines

Responsible for:

The Senior Database Developer is responsible for designing, developing, and implementing sophisticated database solutions that drive our business forward. Your expertise will not only contribute to the development of efficient, scalable, and reliable PL/SQL applications but will also help shape the future of our data management practices.
The Senior Database Developer is responsible for production support of all software and integrations developed by the Software Engineering teams, including but not limited to EDI, XML and flat file integrations, managed file transfers, and database integrations, web applications and APIs. The Senior SQL Developer is also responsible for creating new integrations or making changes to existing integrations in accordance with the engineering teams' coding standards and best practices.

Main Activities and Responsibilities:

Management and support of database solutions:

• Perform optimization and tuning to support high transaction volume, complex query workloads and improve overall database performance.
• Identify and resolve performance bottlenecks in SQL Queries and database operations.
• Perform regular database maintenance tasks, including backups, restoration, and upgrades while ensuring minimal downtime.
• Establish and maintain robust database security practices, including but not limited to role-based access controls, encryption, and vulnerability assessments.
• Quickly address database-related incidents and provide long-term solutions to prevent recurrence.
• Uphold best practices in code health, testing, and maintainability.
• Provide 3rd level escalation for production support issues and customer concerns.

Process automation design and application builds:

• Design, develop, and optimize PL/SQL programs to meet business requirements and project timelines.
• Conduct thorough testing and debugging of PL/SQL procedures to ensure performance and reliability.
• Design and implement data integration solutions to extract, transform, and load data from various sources into the database.
• Perform data analysis, mapping and create migration plans for projects involving application and database migration
• Develop ETL processes to ensure data quality, consistency, and accuracy.
• Implement data integration solutions to synchronize data across different systems.
• Work with stakeholders to understand data requirements and design scalable ETL workflows.
• Collaborate with cross-functional teams to gather requirements, design logical and physical database structures, and ensure data integrity and security.
• Analyze and predict future database capacity requirements and proactively plan for scalable solutions.
• Implement monitoring, logging, and observability solutions to oversee system performance, troubleshoot issues and seek opportunities for improvement.
• Document and maintain comprehensive database logs and records regarding system modifications and updates.
• Document database designs, schemas, and processes to ensure knowledge transfer and maintain system documentation.
• Follow prescribed SDLC & DevOps processes as well as comply with security best practices & policies.
• Adhere to best practices in database development, version control, and change management.

Technical Skills improvement & Mentorship:

• Recommend, design and develop training courses to improve team's overall technical competency.
• Continuously explore and integrate emerging database technologies and methodologies to enhance the data offerings.
• Provide supervision and mentorship to junior staff.

Other:

• Perform miscellaneous duties and projects as may be requested from time to time by the Software Development Lead.

Core Competencies:

Leadership

• Provide leadership & support to junior staff, appraise their performance (If applicable)
• Ensure team & individual Key Performance Indicators (KPIs) are met (if applicable)
• Role model & hold others accountable for demonstrating our values & behaviors
• Lead function, team, self & others through change, whilst maintaining operational effectiveness
• Drive & implement innovation & improvement in function/team

Systems Processes & Policy

• Ensure all policies & procedures are adhered to, including compliance obligations
• Implement functional organizational design & optimal workforce planning
• Ensure key function policies are in place & are current
• Drive & implement operational excellence in function / line of business
• Ensure compliance within function / line of business

Client & Stakeholders

• Establish & maintain effective working relationships with Managers & peers, employees & key stakeholders
• Establish & maintain internal & external collaborative relationships, including with functional & industry associations, managers, peers & direct reports
• Establish & manage effective relationships with key stakeholders, internal & external, including with functional & industry associations, vendors, Board & Executive team

Key Skills and Capabilities:

• Understanding of SDLC
• Scrum, Agile Methodology
• Strong proficiency in SQL (MS SQL and pgSQL) programming, including complex query writing and optimization.
• Knowledge of data modeling techniques and database design principles.
• Experience with ETL tools (SSIS, ADF, AWS Glue) and processes.
• Expert understanding of SQL, query analysis, and performance tuning in PostgreSQL. Strong grasp of database principles, backup and recovery techniques, and replication
• Proficiency in managing database security, replication, and scalability issues.
• Proficiency Data Access and Databases (Microservices, REST APIs, PostgreSQL, AWS Glue)
• Familiarity with cloud services (e.g., AWS) and the ability to work with diverse database technologies (e.g., Postgre, MS SQL).
• Knowledge of modern database monitoring tools and techniques.
• Experience in infrastructure as code is an advantage
• Familiarity with CI/CD tools (GitLab, Azure DevOps) and principles is a plus.
• Knowledge of network architectures, cloud security, and compliance frameworks is a plus.
• Strong Analytical skills
• Strong interpersonal, organizational, problem-solving and conflict resolution skills
• Excellent communication skills, both written and verbal, capable of conveying complex information in a straightforward, understandable manner.
• Ability to build relationships & work collaboratively with clients and organizational peers
• Attention to detail and ability to work in a fast-paced, evolving environment while maintaining high standards of accuracy and confidentiality.

Qualifications and Typical Experience:

• Bachelor's degree in Programming, Computer science and other relevant degrees
• 5+ years experience within similar role with at least 3 years technical experience in PostgreSQL
• Experience working directly with clients

Other Position Requirements:

• Subject to business demands, additional hours may be required
• May be required to travel and work across various sites

Back to search results

Once you find the job that you want, clik Apply. Please check your email for the next steps of the process.

Step 1: Search for Jobs

You can look for jobs through our search box and filter them by jobs profile and location. If there's no current job opening, don't worry. Just make sure that your profile is complete so that we can provide more job opportunities for you.

Step 2: Apply

Once you find the job that you want, clik Apply. Please check your email for the next steps of the process.

Step 1: Search for Jobs

You can look for jobs through our search box and filter them by jobs profile and location. If there's no current job opening, don't worry. Just make sure that your profile is complete so that we can provide more job opportunities for you.

"The company has a cozy, professional yet comfortable working environment and the fact that the management can easily address an issue, it feels like I'm being taken good care of. I really feel like it's my second home."

Career Hub Open from 9AM to 5PM

Corporate Responsibility Company with a cause

MicroSourcing's Corporate Responsibility arm is driven by our long-standing mission to contribute to a developing society. Read more

MicroClubs Let's build the community

MicroCrew is a team of creative and empowered leaders that work to create a more vibrant, close-knit MicroSourcing community through 5 main committees: Dance and Music, Sports, Photography, Volunteering, and Events. See more

Other MS Sites Take your job hunt to the next level

Prospective clients from all over the world looking for staff members will have access to your profile and could potentially offer you your dream job.

Be a recruiter

MicroRefer is the official referral portal of MicroSourcing. Get rewards for referring talented people at MicroSourcing. Find out more here :

Like us on Facebook Thanks, we like you back.

Share this page Tell your friends. Get the word out. We'll love to have them too on board, seriously.

Get Started With MicroResumes Jumpstart your career and discover a world of possibilities

About MicroResumes

Welcome to MicroResumes, MicroSourcing's one-stop recruitment portal for multinational job opportunities By registering, you can search for jobs, track your applications and receive recruiting tips from our Talent Acquisition team. Join MicroSourcing today and discover a world of possibilities.

#J-18808-Ljbffr

---