Senior SQL Database Engineer responsible for technical ownership of Microsoft SQL Server and PostgreSQL environments supporting Pacific Life Re's global business.
Supports FIQ client engagements where the warehouse runs on an IBM i (iSeries / AS/400) WMS, focusing on WMS data extraction, modeling, and integration.
Responsibilities
Extract, transform, and deliver WMS data from DB2 on iSeries to BI and reporting platforms
Own the WMS data model on each engagement: table structures, relationships, and field definitions
Turn operational questions into accurate, repeatable queries and data feeds
Support WMS integrations with WCS, LMS, ERP, TMS, and MHE, including data mapping and testing
Help clients move from ad hoc data pulls toward governed, scalable reporting and modern data platforms
Design and develop data integration solutions for a Financial Services Corporation
Compensation
Pay range: $60.00 - $70.00 per hour
Responsibilities
Design and develop data integration solutions, including data/batch processing, data manipulation, data mining, and data extraction/transformation/loading
Utilize Python/Pyspark and AWS tools to deliver business value in line with company objectives
Lead technical contributor to the enhancement and maintenance of Charles River IMS modules, driving platform innovation and modernization.
Locations (2)
Gdansk, Pomeranian, Poland
Krakow, Poland
Compensation
Minimum Salary: zł282 000 Annual
Responsibilities
Design and implement scalable, performant and highly available distributed database solutions
Collaborate with peers across scrum teams to design and deliver database design conforming to database best practices and meet business and application requirements
Create and maintain comprehensive documentation of database design, data models, configurations, and processes
Write complex SQL queries, stored procedures, and scripts to support application development
Optimize performance through indexing, SQL query optimization, and other database tuning techniques
Provides technical direction, guidance and support for architectural development that encompasses multiple technology disciplines, platforms and applications.
Compensation
Pay Range: $111,605.00 - $131,300.00
Responsibilities
Design and implement scalable Databricks Lakehouse architectures supporting enterprise data processing, analytics, and high-volume workloads.
Develop data solutions using Databricks, Python, PySpark, Databricks SQL, and Delta Lake.
Modernize and migrate complex Oracle SQL and PL/SQL workloads to Databricks and cloud-based data platforms.
Design and implement high-volume ETL/ELT pipelines, data ingestion, transformation, orchestration, and integration solutions.
Optimize Databricks performance, including SQL queries, data layouts, compute utilization, jobs, and distributed data processing.
Responsible for installing, maintaining, and supporting the IMS V15 environment, including system programming, backup, recovery, and performance tuning.
Responsibilities
Perform IMS V15 system programming and application of fixes
Carry out scheduled administrative activities such as system start-up and shutdown
Perform problem determination and resolution for IMS system software and related products
Define and implement policies for disk storage, CPU limits, and backup strategy
Administer and maintain IMS systems, including running backups and recovering corrupted data
Requirements
Nice to have: ITIL Change and Configuration Management
Consultant SpecialistNewHSBC · Xi'an, China
Senior Database EngineerState Street · Gdansk, Poland+1 more
Data Engineer - Pharmacy Data & SQL ServerChiri · South America
Systems Architect 2 - Cloud Data Engineer (Databricks)U.S. Bank National Association · Cincinnati, US
IMS DB System AdministratorCognizant
Technical Lead-Enterprise AppsBirlasoft Limited · Pune, India