Startekk
Mainframe Systems Programmer / Mainframe DBA - Los Angeles, CA (Hybrid)
Be an Early Applicant
Leads and supports mainframe and enterprise database administration, including DB2, IMS, ADABAS, Oracle, MySQL, PostgreSQL, and SQL Server environments. Responsibilities include database upgrades, migrations, installations, performance and capacity monitoring, backup and recovery, replication, partitioning, cloud database transfers, ETL troubleshooting, and production support. The role also provides database design recommendations, develops scripts and procedures, and consults with application development and operations teams.
Company Description
- StarTekk’s adoption of Digital Transformation is to accelerate organizational growth, increase efficiencies and help Star Workforce achieve focused business goals. The Employee will help our organization to identify and bridge the gap that exists in the business by analyzing the data, scale and support digital transformation initiatives.
We are seeking a highly experienced Mainframe Systems Programmer / DBA to lead and support complex database upgrade projects, modifications, installations, testing, implementations, maintenance, and enhancements of new and existing system software products.
The selected candidate will plan, install, configure, test, implement, and manage core database and software products supporting enterprise database architecture and business needs. The role may involve working with DB2, IMS, and ADABAS/NATURAL environments.
Required Skills :
- Manage hierarchical (IMS), relational (DB2), and file-based (ADABAS) databases.
- Plan and execute database environment upgrades and migrations.
- Monitor and verify database health, performance, and capacity.
- Provide database administration consulting to application development and operations teams.
- Perform technical reviews and evaluations of existing DBMS environments.
- Provide database design recommendations to project teams.
- Develop logical and physical database designs.
- Create physical databases and logical database overviews.
- Perform database capacity planning.
- Develop and maintain backup and recovery procedures.
- Perform database performance and space monitoring.
- Conduct database reorganizations, replication, compression, and partitioning.
- Support production database environments and complex database projects.
Mainframe Technology Skills :
- IBM z/OS
- IMS
- DB2
- ADABAS
- SMP/E
- JCL
- IMS DB/DC
- CICS
- ACF2
- Assembler
- COBOL
- REXX
- IBM File Manager
- DELTA/IMS
- NATURAL / SUPERNAT
- EntireX
- CA SPOOL
- IMS & DB2 BMC Tools
- N20/TRIM
- Minimum 7 years of experience as a Systems Programmer / DBA.
- At least 3 years of experience in a lead role.
- 4+ years of database administration experience in Oracle, MySQL, PostgreSQL, and/or Microsoft SQL Server environments.
- 3+ years of experience transferring, validating, and maintaining databases in cloud environments.
- 5+ years of experience utilizing StarQuest Stelo Data Replication software.
- Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related field required.
- Assessing, planning, and migrating databases to cloud environments.
- Transferring, validating, and maintaining databases in cloud environments.
- Installing, configuring, and supporting Oracle Enterprise Edition 19c and 21c on Linux.
- Supporting Oracle databases as backends for public-facing web applications and internal data warehousing.
- Installing and configuring MySQL and PostgreSQL databases.
- Installing and supporting Microsoft SQL Server instances.
- Configuring and supporting Oracle Application Express (APEX).
- Configuring Oracle gateways connecting SQL Server, MySQL, and PostgreSQL instances to Oracle databases.
- Oracle Spatial implementation and support.
- Building custom ETL utilities using cron/crontab, SQLLoader, and PL/SQL.
- Database administration including patch installation, cloning, backup/recovery, and script development.
- Windows batch scripting, Unix shell scripting, and PL/SQL.
- Troubleshooting and resolving ETL job issues.
- Setting up and supporting connectivity to remote database servers using Stelo Data Replication software.
- Monitoring and troubleshooting full and incremental data transfers.
Similar Jobs
Artificial Intelligence • Cloud • Machine Learning • Mobile • Software • Virtual Reality • App development
Designs and develops integrated RF and wireless systems for Spectacles hardware. Responsibilities include creating schematics, overseeing PCB and flex layouts, developing prototypes, executing RF validation, debugging baseband and RF circuits, selecting components and chipsets, and documenting designs. The role collaborates with mechanical, software, industrial design, and supplier teams, and requires expertise in RF analysis, wireless standards, high-speed digital interfaces, simulation tools, and RF test equipment.
Top Skills:
4G Lte5GBleBluetoothCad LayoutCadence AllegroCst Microwave StudioEmiEmmcFlex PcbGnssImpedance MatchingKeysight AdsMatlabMipi CsiMipi DsiNetwork AnalyzersOrcad CaptureOscilloscopesPcbPcieRf Pcb DesignRf SystemsRigid-Flex PcbSdioSignal IntegritySpectrum AnalyzersUfsWifiWireless SystemsXfdtd
Artificial Intelligence • Big Data • Healthtech • Software • Biotech
Lead customer implementations of SOPHiA GENETICS genomic analysis solutions, from planning and sample selection through configuration, training, adoption, and issue resolution. Manage MaxCare Program schedules, timelines, sampling strategies, Statements of Work, technical setup, and cross-functional delivery. Translate laboratory, bioinformatics, data, and clinical regulatory requirements into practical solutions while building trusted customer relationships. The field-based US role includes approximately 30% travel.
Top Skills:
BioinformaticsCustom ReportingFederated Sso AuthenticationLibrary PreparationNext-Generation SequencingSophia Ddm Platform
Machine Learning • Payments • Security • Software • Financial Services
Develops, tests, deploys, maintains, and debugs software across the full project lifecycle. Translates business requirements into technical designs, supports production systems, documents solutions, estimates development tasks, collaborates with teammates, and mentors newer developers. The role requires application architecture, SDLC, testing, troubleshooting, and maintenance experience using Java, .NET, and/or Delphi, with Delphi preferred.
Top Skills:
.NetDelphiJava
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
