The Database Platform Engineer II will be a key member of the Infrastructure Engineering team, supporting data Integration, data modeling, data cleansing, and data migration. 

The successful candidate will have extensive experience in collecting business and user requirements, developing functional specifications, and integrating data to engineer automated production solutions for robustness, reliability, and operational simplicity. You will manage the planning and documentation of database server designs and DB management best practices to ensure system scalability, security, performance, and availability.

• Lead efforts to provision database infrastructure using infrastructure as code tooling.
• Install, configure, test, validate, maintain, and monitor various database systems, application software, and system management tools with automation.
• Maintain expanding portfolio of enterprise database systems and their upgrades, patches, maintenance tasks, performance monitoring and tuning, capacity planning, and availability of sites and services.
• Acts as a technical resource to our business partners in all phases of the development and implementation process; assist with incident and problem resolution as needed.
• Works with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment.
• Studies data sources by interviewing users; defining, analyzing, and validating data objects; identifying the relationship among data objects.
• Plans data integration process by developing common definitions of sourced data; designing common keys in physical data structure; establishing data integration specifications; examining data applications; examining data models and data warehouse schema; determining best-fit data interchange methods; assessing middleware tools for data integration, transformation, and routing; developing project scope and specifications; identifying factors that negatively impact integration; forecasting resource requirements; establishing delivery timetables.
• Improves data integration by designing and evaluating new data interchange formats; improving physical design; rewriting data policy, standards, and procedures.
• Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs.
• Build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business.
• Design, develop, and deploy data movements using SQL Server Integration Services, TSQL and Stored Procedures.
• Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Conducts integration testing and maintains all integrations/DB systems.
• Assures adherence to change management processes and security standards.
• Follow data standards, resolve data issues, complete unit testing, and system documentation for data migration processes.
• Provide development, QA, and production support to troubleshoot day-to-day data-related issues.
• Establish and maintain policies and procedures for Data Registration\Data Architecture.
• Engages in vendor relationship management.
• Set up and managed tools for database monitoring, diagnostics, and performance optimization for the data migration efforts.
• Provide database infrastructure and architecture recommendations to admins supporting tactical and strategic business needs.
• Engages in developing cloud strategies.
• Work with IT operations teams to troubleshoot ETL and MDM issues and optimize the database server environments.
• Partner with application and operations teams to establish and maintain standard operating procedures for data cleansing, data modeling, and data migration.
• Engages in physical infrastructure maintenance; coordinates work activities with server and network operations team.
• Works closely with SFDC admins to build automated workflows to ease admin activities.
• Familiar working with AWS automation tools (Terraform).
• Knowledge in installation and configuration of database clusters.
• Ability to work effectively in a team-oriented environment with strong interpersonal and communication skills.
• Results and deadline-driven; must be willing to do whatever it takes to meet deadlines.
• Solid analytical, problem-solving, and troubleshooting skills.
• Excellent customer service skills and attention to detail.
• Ability to communicate and negotiate with both technical and non-technical colleagues and stakeholders.
• Uphold company mission and values through accountability, innovation, integrity, quality, and teamwork. 
• Support and comply with the company’s Quality Management System policies and procedures. 
• Maintain regular and reliable attendance. 
• Ability to act with an inclusion mindset and model these behaviors for the organization.

• TO BE LOCATED IN TIJUANA, BAJA CALIFORNIA
• Bachelor’s degree in Management Information Systems, Computer Sciences, or field as outlined in the essential duties.  
• 5+ years of experience with Oracle or SQL Server Integration Services (SSIS). Postgres tuning.
• 5+ years of experience in T-SQL and writing efficient and highly optimized SQL queries.
• 4+ years of complete data analysis/mapping and data profiling.
• 4+ years of experience setting up SQL Server 2012/2016/2017/2019 features for large database environments and geographically distributed production data centers.
• 3+ years of experience in database modeling and data design of OLTP and OLAP applications.
• 3+ years of experience with retrieving and loading data from/to various SaaS-based cloud platforms. 
• 3+ years of experience with Agile methodologies.
• 3+ years of experience in Amazon Web Services or other cloud environments.
• Demonstrated ability to perform the Essential Duties of the position with or without accommodation.
• Authorization to work in the United States without sponsorship.

Preferred Qualifications

• Microsoft SQL Server DBA Certification and/or AWS Database Certification or equivalent.
• Experience with PostgreSQL in the cloud, including Amazon RDS.
• Experience with MySQL, MongoDB, and MariaDB.