URGENT Database Engineer L3 DWBI (Temporary WFH)

URGENT Database Engineer L3 DWBI (Temporary WFH)

Electronic Commerce Payments Inc
Metro Manila / NCR
8 - 10 Years
Not Specified

Job Description

Duties includes and are not limited to collection and consolidation of data from different sources and formats into standard data models, transformation of data into critical information. The DB Engineer devises solutions to be able to keep data available, secured, accurate, reliable, and easily accessible to users for consumption and other systems for integration. As Technical Lead, he/she serves as a subject-matter and leads a team of Database Engineers or similar roles. This role is the first point of escalation for high priority and/or complex requests.

Key Duties and Responsibilities 

• Serves as the subject matter expert and the first point of escalation for high priority and/or complex requests
• Handles highly complex, cross-functional, and enterprise IT and business intelligence solutions
• Leads and organizes projects
A. Project Planning

• Translates business and functional requirements into technical requirements and solutions
• Participate in project management estimation
• Develop and manage activities and timelines
• May participate in the development of business cases of other IT projects
• Coordinates with Business/BI Analysts to understand requirements
B. Development and Deployment 

• Designs, develops and tests solutions such as databases, objects, data warehouses, T-SQLs, ETLs, reports and dashboards
• Supports in the integration of BI solutions with other systems
• Analyzes requirements to ensure technical and SOP impacts are considered
• Limits the number of non-standard solutions and escalates with proper documentation when necessary
• Continually attempts to improve performance and efficiency
• Collaborates with Business/BI Analysts and other groups to strategically identify business needs and to clarify objectives
• Creates and maintains standard and detailed procedures concerning dataset development
• Provides top level expertise on data solutions that potentially can be leveraged across the organization
• Researches emerging technologies and analyzes the benefits of adopting those technologies
• Explores data and discovers meaningful patterns and trends such as anomalies
• Enforces and reviews documentations
C. Quality Assurance

• Establish data dictionary and standards
• Recommends improvement in data dictionary and standards
D. Production Support and Maintenance

• Analyzes performance issues and implement performance tuning and optimization
• Tracks and resolves data inconsistencies
• May recommend changes and enhancements to improve system efficiency
• Recommends temporary workarounds to issues until permanent fixes are implemented
• Seeks technical assistance from other teams when issues require coordination
• May implement software/hardware changes as necessary
• Performs capacity and workload planning
• Recommends changes and enhancements to improve system efficiency
• Implements software/hardware changes as necessary
• Performs RCA and devises long-term resolution to recurring issues and problems
• Engages with 3rd party vendors for support as necessary
E. SOP

• Ensures adherence
• Establishes standard models and SOPs
F. Customer Service

• Informs end-users about issues and enhancements that may affect them
• Train end-users how to utilize BI tools
G. Mentoring

• Provides assistance, guidance and training to other members
Job Qualifications, Skills and Competencies
 
• Bachelor's degree in Computer Science, Information Technology, Computer Engineering or specialized training/certification. Or equivalent work experience.
• MS SQL Server (2005, 2008, 2008R2, 2012, 2017+)
• Windows Server (2008, 2008R2, 2012, 2012R2+)
• T-SQL, SSIS, SSRS, SSAS, C#
• Visual Studio
• PowerBI or the likes, Excel
• ERD, logical and physical data modeling
• 8+ years of experience in MSSQL 2012 or newer
• At least 5 years of experience supporting a major system
• In-depth knowledge of the industry and multiple business functional areas
• Can juggle multiple projects with minimal supervision
• Continuous deployment, change management experience
• Advanced proficiency in data analysis and data mining
• Advanced proficiency in DWBI
• Experience leading teams
• Off-hours support is required as needed

Who We Are

Electronic Commerce Payments Inc. (ECPay) is the leading electronic payment service provider in the Philippines. ECPay’s multi-payment platform payment infrastructure operates as a secure electronic depot for Electronic Loading, Bill Payments, Airline Ticket Payments, Cash-in Service and Online Shopping Transaction Payments.

For over 16 years, ECPay has built its network by enabling retail outlets and collection partners to offer accurate, secure and timely payment services to their customers while providing merchant and biller clients with real-time electronic reconciliation, web-based reporting and system management.

ECPay’s operations hub is a complement of over 100 employees, dedicated in providing consistent and timely delivery of ECPay services, products and information to its clients. ECPay’s Sales Team, Technical Support Group, Business Applications Development Team and 24/7 Call Center staff ensure that clients receive the highest grade of service.

ECPay is the most
Convenient Platform
for Payments.
Aside from being able to pay your bills at our payment partner outlets nationwide, you can also top-up your mobile phone credits, reload your accounts and use the services of our accredited partners.

What We Do

ECPay focuses on delivering value to its stakeholders — our partners, and ultimately, the end-users that they serve. ECPay provides the backend payment solution for its retail and collection partners thru its wide array of services ranging from Bill Payments, Electronic Prepaid Mobile Phone Top-Up Loading, Electronic Pins, E-Wallet and Cash Card Reloading, Airline Ticket Payments, Online Shopping Payments and Credit Card Payments.

To date, ECPay serves as one of the biggest third-party electronic payment service providers for more than 150 Billers and Merchant Partners. Our Biller and Merchant partners is a complement of Water and Power Utilities, Telecommunications, Airline Companies, Online Shopping Merchants, Cables, Loans, Insurance and Health Maintenance partners in the country.

ECPay has a nationwide merchant network of over 9,000 sites located in Convenience Stores, Service Stations, Supermarkets, Department Stores, Malls, Pawnshops, Remittance Centers and other Retail Outlets nationwide, providing ECPay’s services to its end-customers.

About Recruiter

15

Followers

22

Active jobs

Functions : IT, IT/Software Development - Application Programming/Maintenance

Industries : IT/Computers - Software

Skills/Roles I hire for: Dba, Software Developer, Qa, BA, Systems Admin

level Hiring For: Junior Level, Mid Level, High Level

Similar Jobs

People Also Considered

Career Advice to Find Better