SQL DEVELOPER
Outsource Accelerator
Date: 3 hours ago
City: Pasig City
Contract type: Full time
Role Summary
Seeking a mid–senior level SQL Developer with a strong focus on database performance and troubleshooting. This role owns query tuning, indexing strategy, and overall database performance, while working closely with internal support teams to investigate and resolve production issues impacting users.
Ideal for someone who enjoys deep-diving into execution plans, optimizing complex queries, and translating technical findings into clear, actionable insights for non-database stakeholders.
Key Responsibilities
Database & Query Optimization
Seeking a mid–senior level SQL Developer with a strong focus on database performance and troubleshooting. This role owns query tuning, indexing strategy, and overall database performance, while working closely with internal support teams to investigate and resolve production issues impacting users.
Ideal for someone who enjoys deep-diving into execution plans, optimizing complex queries, and translating technical findings into clear, actionable insights for non-database stakeholders.
Key Responsibilities
Database & Query Optimization
- Analyze and optimize complex SQL queries, stored procedures, and views for performance and maintainability
- Design, implement, and maintain indexing strategies (clustered, nonclustered, covering, filtered indexes)
- Review execution plans to identify bottlenecks (key lookups, scans vs. seeks, parameter sniffing, cardinality issues)
- Recommend schema changes (normalization/denormalization, partitioning) to support scalability
- Monitor database performance using built-in tools (DMVs, Query Store, performance counters) and monitoring solutions
- Partner with internal support teams to diagnose and resolve database-related production issues (slow queries, timeouts, blocking, deadlocks, data inconsistencies)
- Investigate incidents, identify root causes, and recommend both immediate fixes and long-term improvements
- Translate high-level issue reports into concrete technical investigations
- Develop internal scripts, tools, and queries to improve issue triage and resolution efficiency
- Collaborate with application developers to review SQL changes prior to production deployment
- Define and document SQL best practices, coding standards, and performance guidelines
- Participate in code reviews and knowledge-sharing sessions focused on database reliability
- Contribute to capacity planning, performance testing, and growth forecasting
- 5+ years of hands-on SQL experience in a production environment (mid–senior level)
- Strong expertise in Microsoft SQL Server
- In-depth knowledge of:
- Query execution plans and optimization techniques
- Index design, maintenance, and statistics management
- Transactions, isolation levels, locking/blocking, and deadlocks
- Joins, subqueries, CTEs, window functions, and complex reporting queries
- Proven experience troubleshooting performance issues end-to-end
- Strong understanding of relational data modeling and schema design
- Ability to clearly communicate technical concepts to both technical and non-technical audiences
- Experience working cross-functionally with support, product, and engineering teams
- Experience with ETL, reporting, or analytics workloads
- Familiarity with ORMs and their impact on SQL performance
- Background in SaaS, multi-tenant, or high-availability environments
- Exposure to monitoring or APM tools
- Scripting experience (PowerShell, Python, Bash) for automation
- Experience with version control and CI/CD practices for database deployments
- Reviewing and refactoring slow or high-cost queries
- Partnering with support teams to reproduce and diagnose issues
- Analyzing execution plans and runtime metrics
- Advising developers on optimal query and schema design
- Creating internal documentation and troubleshooting playbooks
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Customer Success Manager
Acquire Intelligence,
Pasig City
1 day ago
We’re an award-winning global outsourcer providing contact center and back office services on behalf of our global clients. Come work at a place where innovation and teamwork come together to support the most exciting missions in the world!At Acquire Intelligence, our mission is to help businesses work smarter.We bring together the best people, efficient processes, and automation to help companies...
HR Associate
Robinsons Land Corporation,
Pasig City
1 week ago
DepartmentHuman Resources DepartmentEmployee TypeRegularJob DescriptionThe HR Associate is responsible for handling various HR functions, including Talent Management system administration, HR analytics, HR special projects, and other HR-related tasks. The role requires strong organizational skills, attention to detail, and the ability to handle sensitive and confidential information.Job Responsibilities Darwinbox Administration To serve as the primary point of contact for Darwinbox ,...
Service Associate
RCBC,
Pasig City
2 weeks ago
Job SummaryProvides competent, timely and error-free over-the-counter services to customers in the Business Center.Ensures compliance with internal policies, Banko Sentral ng Pilipinas (BSP) / Anti-Money Laundering Act (AMLA) regulations and other external regulatory rules.Recognizes risk areas and eliminates risks by consistently implementing bank policies and procedures.Supports business objectives through excellent customer service delivery and other service-related initiatives of the branch.Willing...
