Distributed Computing Engineer - PostgreSQL DBA Engineer Vice President
Full-time
8 months ago
Employment Information
SMBC Group is a top-tier global financial group. Headquartered in Tokyo and with a 400-year history, SMBC Group offers a diverse range of financial services, including banking, leasing, securities, credit cards, and consumer finance. The Group has more than 130 offices and 80,000 employees worldwide in nearly 40 countries. Sumitomo Mitsui Financial Group, Inc. (SMFG) is the holding company of SMBC Group, which is one of the three largest banking groups in Japan. SMFG’s shares trade on the Tokyo, Nagoya, and New York (NYSE: SMFG) stock exchanges.
In the Americas, SMBC Group has a presence in the US, Canada, Mexico, Brazil, Chile, Colombia, and Peru. Backed by the capital strength of SMBC Group and the value of its relationships in Asia, the Group offers a range of commercial and investment banking services to its corporate, institutional, and municipal clients. It connects a diverse client base to local markets and the organization’s extensive global network. The Group’s operating companies in the Americas include Sumitomo Mitsui Banking Corp. (SMBC), SMBC Nikko Securities America, Inc., SMBC Capital Markets, Inc., SMBC Rail Services LLC, Manufacturers Bank, JRI America, Inc., SMBC Leasing and Finance, Inc., Banco Sumitomo Mitsui Brasileiro S.A., and Sumitomo Mitsui Finance and Leasing Co., Ltd.
The anticipated salary range for this role is between $100,000.00 and $180,000.00. The specific salary offered to an applicant will be based on their individual qualifications, experiences, and an analysis of the current compensation paid in their geography and the market for similar roles at the time of hire. The role may also be eligible for an annual discretionary incentive award. In addition to cash compensation, SMBC offers a competitive portfolio of benefits to its employees.
Role Description
This role is for a Distributed Computing Engineer - PostgreSQL DBA Engineer within the Systems Infrastructure department in technology. Job duties include PostgreSQL DB environment maintenance, monitoring, DB installation, backup and restore, database replication, database development and tuning, user supports, security hardening such as CIS deployment and maintenance. The candidate will work within the DBA team and will interact with members of the infrastructure team, front office developers, PM and business users.
This position will be primarily located in the New York office. You will work in a fast-paced environment to provide support the trading business for Front/Middle/Back office.The candidate must have strong knowledge of PostgreSQL Servers, Database management, security enhancement including CIS benchmarks for PostgreSQL and AD authentication.
SMBC Capital Markets, Inc. is a market maker for swaps, including interest rate, currency and commodity swaps and related derivative products, headquartered in New York as a wholly-owned subsidiary of SMBC. SMBC Capital Markets, Inc. was provisionally registered as a swap dealer with the Commodity Futures Trading Commission on December 31, 2012. Our business works in close collaboration with SMBC Nikko Capital Markets, Capital Markets Limited in the UK, and SMBC Capital Markets Asia, Ltd in Hong Kong to provide global coverage to SMBC’s corporate, institutional, and project clients. Capital Markets maintains its own middle and back-office functions, including Risk Management, Compliance, Systems, Finance, and Operations.
Role Objectives
- Support PostgreSQL Server platforms (PostgreSQL 15)
- Provide system administration, troubleshooting, monitoring, DB installation, DB backup and restore, database replication setup and maintenance, database development and tuning, user supports, security hardening such as CIS deployment and maintenance.
- Research and recommend innovative solutions and where possible automated approaches for system administration tasks
- Implement monitoring tools and proactively implement improvement steps to prevent potential issues. Troubleshoot and solve incidents quickly to maintain the high availability environment.
- Carry out annual DR test.
- Work with Cybersecurity and audit teams to satisfy se
- Late night and weekend work may be necessary at times for installations, patching, upgrades, and maintenance
- Follow the change control processes and procedures
- The candidate is required to update/maintain all documentation and will be tasked with improving such documentation as required.
- Maintain effective communication with the Systems Infrastructure team and management
Qualifications and Skills
We are looking for a PostgreSQL DBA Engineer with 5 to 10 years of experience
- Experience with PostgreSQL 15 administration.
- Experience with installation, configuration and maintenance of PostgreSQL on Redhat OS
- Experience with Linux (Redhat)
- Experience with high availability and disaster recovery, backups/restores
- Understanding on change control, upgrade, and release deployment activities
- knowledge of database security, access control, monitoring, and auditing
- Experience with DB authentication via AD or Azue AD
- Experience with monitoring, tuning, and analyzing database performance
- Experience that is a major plus:
- Experience with Microsoft SQL Server administration
- Working experience in a financial environment
Required Skills / Abilities:
- Excellent customer service skills
- Excellent verbal and written communication skill
- High sense of urgency as a Trading Floor environment needs to be supported
- Able to follow directions, priorities, and guidance from management
- Ability to multi-task and work on several projects at the same time
- Strong ability to deliver on time
- Ability to document process, requirements, and create test plans
- Strong ability to translate business requirements into technical solution
- Strong team player
Additional Requirements
D&I Commitment
Responsible for fostering a culture of diversity and inclusion, holding leaders accountable for creating an inclusive environment through awareness and practice of equity in recruiting, developing, and promoting diverse talent.
SMBC’s employees participate in a hybrid workforce model that provides employees with an opportunity to work from home, as well as, from an SMBC office. SMBC requires that employees live within a reasonable commuting distance of their office location. Prospective candidates will learn more about their specific hybrid work schedule during their interview process.
We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law. SMBC provides reasonable accommodations for employees and applicants with disabilities consistent with applicable law. If you need a reasonable accommodation during the application process, please let us know at accommodations@smbcgroup.com.
Share this
