DST Systems Mainframe DBA Administrator in Kansas City, Missouri
The speed of technology. The influx of data. Shifting regulations. Increased customer expectations.
That's where you'll find DST, helping clients find opportunity in ever-changing and complex customer, business, and regulatory requirements. Mastering complexity is a constantly changing and evolving challenge – one that only a few people can embrace and thrive upon.
If you see your opportunity in complexity, then we are the right fit for you.
As an Associate with DST Pharmacy Solutions, you will be part of an organization that promotes better health outcomes for consumers through clinical and technological innovations. We accomplish this by leveraging the robust technology foundation and powerful analytic resources that are the core of DST, with industry leading clinical expertise and strategic pharmacy and healthcare solutions. You will join a team that is redefining the value of pharmacy in healthcare through the integration of advanced analytics, clinical insights and transformative digital capabilities.
Designs and develops data storage systems, processes and enhancements for company's complex high traffic, business critical internet site communications and/or network-based (cloud) product systems. Leads the design of enterprise storage environments, including enterprise storage arrays, fiber channel switches and Network Attached Storage (NAS) physical and virtual tape devices. Develops solutions and processes for reliable and stable data storage management, security, backup, restoration, archiving and replication. Assists with the implementation of new or additional storage technology to improve infrastructure service locally and remotely.
This position supports Mainframe DB2 database administration work for Pharmacy Solutions business unit. Associate will be working on data refreshes copying data across DB2 platforms, work with project team in defining DB2 database tables, to build logical and physical database designs, DB2 backup strategy and SQL performance tuning recommendations.
Bachelor’s degree and 2 years of work-related experience, or 4 years equivalent work-related experience
Strong knowledge of Db2 for z/OS DDL, DML, DCL writing and execution
Strong understanding of Db2 for z/OS database components, concepts, subsystem function, and internals
Experience in building high performance logical and physical database designs with emphasis on business objectives that drive design decisions
Mastery of IBM DB2 utilities such as Unload, Load, REORG, Image Copy, RUNSTATS
Experience with test data refresh processes using Db2 utilities.
Ability to analyze, diagnose and resolve database issues and assist applications teams with database-related application issues.
Ability to work collaboratively with application teams, systems teams, and teammates to meet client database needs
Ability to analyze, test, and recommend new database features, functionality, and products that can yield improvements for the database environment
Knowledge of SQL and SQL performance analysis that results in improved database application performance
Experience completing and managing DBA service requests from client teams to meet project deadlines or resolve support issues
Experience with a IBM database change and catalog tools
Experience with a database performance monitoring tools, DB2 Explain, access path evaluation
Ability to perform database recoveries
Excellent communication skills, written and interpersonal
Must be available off-hours for deployments, support, and monitoring as needed
Must be able to comply with periodic pager duties for 24 X 7 database support
Knowledge of Analytics capability and IDAA fundamentals not mandatory but a plus
Knowledge of IBM Data Studio /DSM not mandatory but a plus
Ability to perform problem determination for Transactional or Batch workload utilizing Db2, z/OS, system tooling
Knowledge of CICS and z/OS constructs and infrastructure
Ability to be self directed and proactive to perform ongoing performance analysis and recommend improvements for Db2 infrastructure and application database constructs
Kansas City Missouri
DST is an equal opportunity employer and values a diverse and inclusive workplace. All qualified candidates will receive consideration for employment without regard to age, race, color, religion, genetic information, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. For more information about Equal Opportunity in the Workplace please click here and here. DST is committed to working with and providing reasonable accommodation to job applicants with disabilities. If you are a qualified individual with a disability and need an accommodation or accessibility assistance to complete the online application, please contact us at PeopleCenter@dstsystems.com for assistance.
SS&C DST is a leading provider of specialized technology, strategic advisory, and business operations outsourcing to the financial and healthcare industries. Combining unmatched industry knowledge, critical infrastructure and service excellence, SS&C DST helps companies master complexity in the world’s most demanding industries to ensure they continually stay ahead of and capitalize on ever-changing customer, business and regulatory requirements.
We work with companies in some of the world’s most demanding industries where rapid shifts in consumer, regulatory, and technology trends are increasingly affecting how our clients do business. For them, keeping up in a landscape of constant change is becoming more and more complex. Through our technology, strategic advisory, and business improvement solutions we work with clients to help them stay ahead of and capitalize on customer, business, and regulatory change.
Mastering complexity is not an end-state. It’s a constantly changing and evolving challenge – one that only a few people can embrace and thrive upon. If you see your opportunity in complexity, then we are the right fit for you.