Production Support Engineer (Overnight)

Docupace Technologies, LLC
United States
3 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$80,000 - $90,000
Working hours
Shift work
Job source

Tech stack

Secure Shell (SSH) Microsoft Windows Bash Shell Databases Continuous Integration Data Integrity Extract Transform Load (ETL) Relational Databases Software Debugging Linux DevOps Monitoring of Systems
+21 more
Log Analysis Microsoft SQL Server Oracle (Applications) Oracle SQL Developer Reliability Engineering PL-SQL Subversion Toolchain Transact-SQL Visual Studio Online Web Applications Data Processing Scripting Remote Desktop Protocol (RDP) File Transfer Protocol (FTP) Gitlab Git Toad (Software) Bitbucket SQL Server Management Studio (SSMS) Software Version Control

Job description

As a Docupace Production Support Engineer, you will work across web application stacks, databases, operating systems, and client data feeds, applying best practices for availability, reliability, and data integrity. You will be part of the Production Support Team within the Technology Team, and the team’s learnings feed back into the Engineering and DevOps groups. This role handles financial services client data that must be processed in the United States. All work, including on-call, must be performed from within the United States, and the successful candidate must pass a background check., * Work the overnight shift (midnight to 9 AM ET, Tuesday to Saturday) as the primary production operator

  • Join the on-call rotation to respond to incidents that impact client site availability and support Customer Success staff with customer incidents
  • Use your on-call shift to prevent incidents from ever happening
  • Investigate incidents with MSSQL, Oracle, log analysis, RDP, SSH, and other monitoring tools
  • Build monitoring that alerts on symptoms rather than on outages
  • Document every action so findings turn into repeatable actions and then into automation
  • Improve operational processes, such as deployments, upgrades, and data loads, so they are predictable and repeatable
  • Run and monitor scheduled ETL imports across inbound client data feeds (custodian, clearing, and transfer-agent files), handle exceptions, and reload missed or skipped files
  • Set up, change, and shut down data feeds, including SFTP pickups and scheduled jobs, through ticketed change control
  • Perform release activities to update staging and production systems
  • Support copying data from production environments to lower environments using automated tooling
  • Debug production issues across services and levels of the stack
  • Develop and debug configurations for our ETL tooling
  • Debug and troubleshoot logical issues in database code (SQL Server and Oracle) for large relational data sets
  • Debug and tune performance issues in database code and queries, including reading execution plans
  • Handle client data under least-privilege and US-only access controls, take part in access reviews, and document actions to audit standard
  • Understand the business domains of the Docupace products you support, such as broker-dealer and RIA compensation and compliance
  • Work in an Agile environment on a cross-functional team, * Sit - Frequent
  • Stand- Occasional
  • Walk - Frequently
  • Lift/Carry 0-20 pounds - Occasional
  • Lift/Carry over 0-20 pounds - Occasional
  • Kneel/crouch, bend and /or stoop repeatedly - Occasional

Requirements

  • Must reside and work in the United States
  • Able to work an overnight schedule (midnight to 9 AM ET, Tuesday to Saturday) on a regular basis
  • 5+ years in production support, site reliability, or database operations
  • Able to pass a background check
  • Experience with securities-processing data, such as custodian and clearing feeds (DST, Pershing, Fidelity/NFS, Schwab, etc.) preferred
  • Familiarity with wealth management operations, such as commissions and compensation processing or compliance surveillance preferred
  • Awareness of financial data-protection rules such as GLBA and Regulation S-P preferred

Knowledge, Skills and Abilities:

  • Strong scripting and database skills: Shell, T-SQL, and PL/SQL
  • Comfortable working on Windows and Linux, including reading application logs
  • Experience running file-based data feeds or ETL jobs in production (SFTP transfers, scheduled imports, exception handling)
  • Working knowledge of VS Code, SSMS, Oracle SQL Developer or Toad, and other IDEs
  • Deployment experience using CI/CD practices and toolchains
  • Ability to use GitLab, Bitbucket, or other version control (Git, SVN, etc.)
  • Collaborates and communicates well asynchronously
  • Documents thoroughly, so the team never has to solve the same problem twice
  • Enthusiastic, go-for-it attitude; when something is broken, you fix it
  • Urge to deliver quickly and effectively, and to iterate fast

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…