.Our PurposeWe work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart, and accessible. Using secure data and networks, partnerships, and passion, our innovations and solutions help individuals, financial institutions, governments, and businesses realize their greatest potential. Our decency quotient, or DQ, drives our culture and everything we do inside and outside of our company. We cultivate a culture of inclusion for all employees that respects their individual strengths, views, and experiences. We believe that our differences enable us to be a better team – one that makes better decisions, drives innovation, and delivers better business results.Title and SummarySenior Database EngineerOverview
- Responsible for defining and maintaining the data architecture and associated data maintenance, integration, and load processes for the organization.ResponsibilitiesIdentifies and selects appropriate technologies, develops, builds, maintains, and tests database technologies, including associated software products.Supports the development of SQL tuning statement procedures to optimize SQL tuning and query development.Supports database security posture which includes escalating potential concerns and implementing both risk mitigation plans and control functions.Design, implement, and maintain scalable database solutions in AWS cloud environments.Optimize ETL processes using AWS Glue and AWS Lambda, SNS, AWS DMS, for data ingestion, transformation, and loading into Redshift.Monitor database performance, troubleshoot issues, and implement solutions to ensure optimal performance and reliability.Implement and manage data pipelines and workflows using AWS services such as Lambda, S3, and DynamoDB.Ensure data integrity, security, and compliance with organizational standards and industry regulations.Automate repetitive tasks and processes to improve efficiency and scalability.Propose and implement an active monitoring system making alert and troubleshooting notification and solution more efficient.Optimize the performance and system scalability of the ETL processes, data storage, and database tuning to re-optimize the system and improve overall performance.Document the changes and processes, with detailed architecture diagrams and descriptions of the processes.ExperiencesGains exposure to automation and/or cloud delivery effort.Knowledge in AWS cloud infrastructure and services for databases implementation and optimization.Experience with databases on Aurora, PostgreSQL, and MySQL.Practical experience in ETL development.Hands-on experience with AWS Glue, AWS Redshift, AWS DMS, AWS Lambda, Amazon EventBridge, Queues, S3, etc.SQL skills and experience in database design, optimization, and performance tuning.Experience in at least one scripting language (Python, SQL, PySpark).Solid understanding of data warehousing concepts, ETL processes, and data modeling techniques