Senior SQL Developer
UNICON International Inc. · Torrance, CA · 2 wk ago
On-siteInformation Technology$124/hrContract
About the role
This role requires strong ownership of end-to-end database solutions including design, development, deployment, and production support in a regulated and audit-compliant environment. As a Senior SQL Developer, this person will perform the following tasks, but not limited to:
Responsibilities
- Lead application development and production support for multiple large-scale enterprise systems
- Perform root cause analysis (RCA) of production issues and implement permanent fixes to improve system stability
- Troubleshoot Mid-tier MS SQL Server online and batch processing issues, ensuring SLA adherence
- Evaluate and optimize daily and monthly batch processes to improve performance and reduce critical path execution time
- Design, develop, and implement database solutions with a focus on scalability, performance, and reliability
- Ensure data integrity, reconciliation, and control mechanisms are in place for all critical data processes
- Deliver complete and audit-compliant documentation for estimates, design, development, and testing artifacts
- Automate monitoring, alerting, and operational processes to improve system reliability
- Participate in on-call production support during off-office hours (night and weekend) and handle incidents based on defined SLAs
- Follow and enforce change management, release, and SOX/audit compliance processes
Requirements
- Strong hands-on experience with Microsoft SQL Server technologies, including T-SQL, SSIS, stored procedures, views, functions, triggers, and indexing strategies
- Experience in Automotive Finance industry preferred
- Strong understanding of auto finance lifecycle (loan origination, servicing, collections, accounting, end-of-term processing, and regulatory processes)
- Experience in test practices and deliverables for unit testing
- Self-starter with ability to work independently in a fast-paced production environment
- Strong communication skills with ability to collaborate across business and technical teams
- Ability to handle high-pressure production incidents and drive resolution to closure
- Detail-oriented with focus on accuracy, auditability, and documentation
- Knowledge of Salesforce Service & Marketing cloud platform is preferred
- Experience in working in Agile and Waterfall methodologies
- Strong expertise in SQL performance tuning, query optimization, and database design
- Experience with batch processing systems and performance optimization of large data volumes
- Experience with version control systems (e.g., Git, Azure DevOps) and CI/CD pipelines
- Experience with data modeling (OLTP and Data Warehouse concepts)
Qualifications
- Bachelors degree in Computer Science, Information Systems, or related field (or equivalent experience)
- 710+ years of experience in SQL development and database engineering
- Proven experience working in large-scale, high-volume transactional systems
- Experience handling production support and incident management in enterprise environments
Skills
- 10+ years of hands-on SQL development experience in enterprise environments
- Strong expertise in T-SQL programming and performance tuning
- Experience supporting production systems with SLA-driven support models
- Experience in Agile and/or Waterfall methodologies
- Strong analytical and problem-solving skills
Pay
$124-129k
Schedule
Onsite (4 days/week)