SQL Developer
Crawford and Company Broadspire Phils., Inc.
- Taguig, PhilippinesFort Bonifacio, Taguig, Metro Manila, PhilippinesTaguigMetro ManilaPhilippinesPhilippines
- ₱72,000.00 - ₱87,000.00 / monthPHP720008700072000MONTH
- Full timeFULL_TIME
Job closed.
Job Description
Summary
Under general direction of the Head of TPA and Affinity Systems, the SQL Developer is responsible for the development, configuration, and maintenance of the database-driven claims management system. This involves introducing a range new and often bespoke functionality including scheduled reporting and data import tasks (SSRS/SSIS) and front end system modifications (T/SQL). This also includes day to day maintenance, modification and performance improvement as well as onboarding new clients/products into our portfolio.
Other key task and responsibilities:
- Builds, develops, and modifies database-driven system and functionality.
- Applies quality and performance design principals, while always bearing in mind the needs of the users.
- Works with clients and key stakeholders to establish and deliver requirements.
- Provides accurate estimates for the time required for creation of database code and then deliver accordingly.
- Translates internal business requirements into technical requirements, in conjunction with specialist Business Analysts.
- Identifies and resolves bugs.
- Creates and updates reports.
- Provides succinct updates on progress to the Project Managers and Head of TPA Systems.
- Contribute with creative programmatic solutions as appropriate.
- Supports testing.
- Arranges releases.
Minimum Qualifications
- Preferably with College or technical school experience in a related field.
- At least 5 years in-depth experience as a Database Analyst Programmer using the following technologies:
- MS SQL Server T-SQL
- Advanced stored procedures, functions, triggers, CTE, Window Functions, error handling) across SQL 2012/2014.
- Query Performance Optimisation
- MS SQL Server Integration Services
- ETL design, development and implementation
- MS SQL Reporting Services
- Change Management Procedures
- Compliance to Data Governance policies
- MS SQL Server T-SQL
- Preferred:
- JSON and XML data formats.
- Business Process Management (BPM) systems.
- Tableau / Cognos / Power View Reporting and Visualisations.
- Experience in maintaining and troubleshooting Dynamic SQL.
- Knowledge of non-Microsoft tools such as Redgate, Idera, APEXSQL, etc.
- General database administration (backups / optimisation / troubleshooting).
- Subversion source control.
Perks and Benefits
- Paid Holidays
- Paid Vacation Leave
- Paid Sick Leave
- Paid Bereavement/Family Leave
- Maternity & Paternity Leave
- Single Parent Leave
- Special Leave Benefits for Women
- Retirement Benefit Plans
- Life Insurance
- Medical / Health Insurance
- Performance Bonus
Required Skills
- NoSQL
- SASS
- ETL
- SQL
- MySQL
Jobs Summary
- Job Level
- Mid-Senior Level / Manager
- Job Category
- IT and Software
- Educational Requirement
- Bachelor's degree graduate
- Recruiter response to application
- Often
- Office Address
- Fort Bonifacio, Taguig, Metro Manila, Philippines
About Crawford and Company Broadspire Phils., Inc.
Based in Atlanta, Georgia, Crawford & Company (www.crawco.com) is one of the world's largest independent provider of claims management solutions to the risk management and insurance industry as well as self-insured entities, with an expansive global network serving clients in more than 70 countries. The Crawford System of Claims Solutions offers comprehensive, integrated claims services, business process outsourcing and consulting services for major product lines including property and casualty claims management, workers’ compensation claims and medical management, and legal settlement administration. The Company’s shares are traded on the NYSE under the symbols CRDA and CRDB.