Database Administrator - DB2 - REMOTE

Company: Edward Jones
Location: Saint Louis
Posted on: May 6, 2021

Job Description:

At Edward Jones, we help clients achieve their serious, long-term financial goals by understanding their needs and implementing tailored solutions. To ensure a personal client experience, we have located our 14,000+ branch offices where our more than 7 million clients live and work. A typical branch office has one financial advisor who meets with clients face-to-face and one branch office administrator who enhances the team's ability to build deep relationships with clients. Headquarters associates in St. Louis and Tempe provide support and expertise to help U.S. and Canada branch teams deliver an ideal client experience. Edward Jones currently has more branch offices than any other financial services firm, and we continue to grow to meet the needs of long-term individual investors.Responsibilities- Designs, develops, implements and supports databases, ensuring acceptable database availability and response time. - Creates logical data models for new databases. - Investigates database performance issues monitors database capacity supports virtual data center concepts and replication and performs software maintenance. - Performs database problem diagnosis and resolution. - Reviews data access code, recommending changes to developers. - Adheres to published standards, policies and best practices for database design, data access, security, storage, and technology lifecycle management. - Understands database applications from a business perspective. Documents procedures and the current database environment. - Complies with audit and regulatory requirements. - Performs database maintenance (reorganizations, statistics), backup and recovery, data refreshes, and disaster recovery planning and testing. - Performs software installation and maintenance, including new releases, database instance creation, major upgrades and software patches, often with assistance from more experienced DBAs. - Diagnoses and resolves basic tuning issues at the operating system or server level. - Provides considerable after-hours and weekend support. Participates in primary on-call rotation. May also be expected to carry pager for secondary coverage.QualificationsBachelor's degree in Business, Mathematics, Computer Information Systems, or Computer Engineering, or equivalent experience. Experience or training in database management technology or software development is preferred. Proficiency with the following is preferred Database tools, such as Platinum, SQL Developer, OEM Grid, Toad Physical and logical replication, such as Data Propogator (DB2), Quest Shareplex or Data Guard (Oracle), Trans log shipping or Data Mirroring (SQL Server) Understanding of and commitment to protecting the integrity, security and privacy of the firm's critical business data. Good interpersonal skills, plus good written and verbal communication skills. Understanding of and adherence to development life cycle methodologies, including Agile. Organizational skills to manage and prioritize multiple tasks. Ability to think and work independently. Good attention to detail. Ability to deal with high-volume, rapid development cycles, many concurrent deadlines and changing priorities. Technical skills as below Skill Level Position Oracle DBA SQL Server DBA DB2 IDMS DBA Expert Proficient Unix or Linux MS Windows MVS or zOS Oracle 9i, 10g, or 11g SQL Server 2000, 2005, or 2008 DB2 or IDMS SQL SQL SQL Installation patching Instance tuning Installation patching SMPE installation patching Replication Tuning Tuning Replication Replication Knowledgeable PLSQL Windows Server Administration IDMS DML Unix scripting COBOL, CICS, JCL P-SQL Real Application Clusters, ASM WMI, or SSIS ASP, .Net Familiar with Java J2EE, or CC++, or Perl, Weblogic, middleware, HTML Data modeling Data modeling Data modeling Problem Solving Database Administrators must be able to identify and resolve basic problems with little assistance. They must also know when to ask for help and escalate to management when problems are beyond the scope of their ability or experience. These problems can often impact the firm's ability to generate revenue, serve clients or comply with regulations. Scheduled DBA work is reviewed by DBA peers and leadership, but review process is not always available when working on after-hours problems with tight deadlines. Decision Making DBAs frequently work independently and with limited supervision. Often, DBAs are consulted on problems with moderate visibility and risk to the firm, with tight deadlines. In situations where database technology is down and clients are being impacted, DBAs are sometimes called on to exercise judgment and make decisions with limited assistance from their leaders. However, as the complexity and risk of the decisions increases, DBAs are expected to engage more senior associates and IS leadership. Span of Influence DBAs work on the databases underlying core business processes. They interact with projectsupport teams, business users, and IS leadership. DBAs have no formal leadership responsibility. FORTUNE 2020 - Edward Jones was named No. 7 on the 2020 FORTUNE 100 Best Companies to Work ForRegistered list. From FORTUNE Copyright2020 FORTUNE Media IP Limited. All rights reserved. Used under license. FORTUNE and FORTUNE 100 Best Companies to Work For are registered trademarks of Fortune Media IP Limited and are used under license. FORTUNE and Fortune Media IP Limited are not affiliated with, and do not endorse products or services of, Edward Jones Investments. Edward Jones Ranked No. 6 of the 100 best workplaces for millennials by Great Place to Work and FORTUNE Magazine. 2020 Corporate Equality Index - Edward Jones joins the ranks of 680 major U.S businesses that received top marks in the HRC Foundations 18th Annual Scorecard on LBGTQ Workplace Equality Edward Jones named a top company for training, ranking No. 25 on Training magazine's 2020 Training Top 125 list - the highest ranking among the financial-services industry! Financial services firm Edward Jones has been named one of the 2019 Best Workplaces for Parents by Great Place to Work and FORTUNE magazine. The firm ranked No. 5 on the list of 50 companies, up two spots from last year. The Best Workplaces for Parents list is one of a series of rankings by Great Place to Work and FORTUNE based on employee feedback from Great Place to Work-CertifiedTrademark organizations. Edward Jones ranked No. 7 on the FORTUNE 100 Best Companies to Work for in 2019 list, the firm's 20th appearance on the list. The firm also was ranked the No. 1 Best Workplace in Financial Services Insurance and the No. 6 Best Workplace for Millennials by Great Place to Work and FORTUNE. Edward Jones does not discriminate on the basis of race, color, gender, religion, national origin, age, disability, sexual orientation, pregnancy, veteran status, genetic information or any other basis prohibited by applicable law.SDL2017

Keywords: Edward Jones, St. Louis , Database Administrator - DB2 - REMOTE, IT / Software / Systems , Saint Louis, Missouri