SQL Developer
Crawford and Company Broadspire Phils., Inc.
- Taguig, PhilippinesFort Bonifacio, Taguig, Metro Manila, PhilippinesTaguigMetro ManilaPhilippinesPhilippines
- 72.000,00 PHP - 87.000,00 PHP / monthPHP720008700072000MONTH
- Toàn thời gianFULL_TIME
Công việc đã đóng.
Miêu Tả Về Công Việc
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.
Trình độ tối thiểu
- 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.
Đặc quyền và lợi ích
- 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
Kỹ năng cần thiết
- NoSQL
- SASS
- ETL
- SQL
- MySQL
Tóm tắt công việc
- Trình Độ Công Việc
- Trình độ nhân viên cấp trung bình / cấp quản lý
- Ngành Nghề
- IT and Software
- Yêu cầu học vấn
- Tốt nghiệp Cử nhân
- Nhà tuyển dụng trả lời hồ sơ
- Often
- Địa chỉ văn phòng
- Fort Bonifacio, Taguig, Metro Manila, Philippines
Về 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.