Database administrator job description

The primary purpose of this role is the installation, monitoring and basic tuning of enterprise-level databases following established database design standards and procedures. The role will also perform database backups and restores to ensure proper recovery procedures are in place. Complies with team standards of database administration methodology. Participates in project teams by implementing database structure that meets requirements and specifications. Participates in disaster recovery exercises. Attends status meetings and/or regularly communicates progress against project activities.
Job Description
Implements, configures and troubleshoots database instances, backups and user access Performs general database troubleshooting, debugging and testing Evaluates and provides technical solutions for moderately complex database tasks/projects Shows a moderate knowledge of the leading enterprise-level RDBMS software packages, utilities and general database concepts Creates or modifies database structures per specifications, on time and on budget in a quality manner Updates database support documents and user documentation Completes medium complexity tasks Complies with database documentation standards within the organization Participates in 24/7 on call support responsibilities including maintenance windows and disaster recovery drills Works with software vendors, application support and developers to resolve moderate database issues. Performs patching on existing databases Resolves production support issues in a timely manner, including during non-business work hours Communicates effectively with manager, peers, and internal customers to relay status of work and raise challenges, concerns, questions, and issues as necessary Collaborates with senior DBAs to help author standard process and support related documents Stays abreast of the new database technologies and help articulate pros and cons to the management team Understands basic database architecture, distributed infrastructure and various network technologies to implement robust and scalable solutions for the organization Configures and installs databases in accordance to change management policies and procedures
Required Education and Experience
Bachelor's Degree in relevant field or 3-5 years IT experience 2-5 years of experience in an IT environment Excellent verbal, written, and interpersonal communication skills Strong analytical and problem solving skills Ability to read and understand software specifications Ability to work irregular hours or schedules to accommodate site needs and to perform assigned duties in an efficient manner
Our Organization has a business casual environment and focuses on teamwork, associate development, training, and continuous improvement. We offer competitive wages, excellent affordable insurance benefits (including health, dental, vision and life), 401K plan, paid vacation and holidays.

Our Organization is an equal

opportunity employer.

Position Overview:

Our DBA II position is a unique opportunity for an individual with prior DBA experience seeking new challenges and looking to broaden their database administration experience/responsibilities. The successful candidate will be responsible for performance monitoring, maintenance and operational support of our entire assortment of databases (165+ Oracle, 350+ MSSQL, 5+ Sybase). This candidate will provide day-to-day production support, troubleshooting, administration and backup/restore of various databases. Responsibilities also include database upgrades, patching and security. We are a very proactive database team, so when not on-call and/or working specific projects, the candidate will be expected to continually assess, improve, and optimize our database environment to eliminate/reduce the possibility of database outages/downtime.

Key Duties and Responsibilities:

Under the direction of the Senior Database Team Lead, and working closely with Senior Database Administrators to ensure that our Oracle, Microsoft SQL Server and Sybase databases perform optimally, including, but not limited to the following:
Monitor performance of database system resources and query performance Monitor and maintain database storage resources Monitor and maintain database maintenance plans for backups, index rebuilds, and statistics updates Perform Oracle, MSSQL, Sybase upgrades, migrations and configuration changes Install database software service packs, cumulative updates and security patching as necessary Maintain database documentation as required Maintain and administer database security access Perform database ad-hoc backups and restores Troubleshoot and resolve database connectivity issues Follow Change Management processes to implement database configuration changes Follow Problem Management processes to troubleshoot and resolve issues Proactively monitor and respond timely to database alerts Optimize SQL code as necessary Rotational, primary DBA on-call requirements to ensure 24x7 support of database operations
Required Basic Qualifications:
Self-starter, with a keen interest in technology and highly motivated towards success Self-sufficient, able to work independently and provide updates to upper Management Possess necessary skills and disposition to provide high quality customer service Strong analytical, research, and problem solving capabilities Strong organizational skills with the ability to prioritize work effectively Excellent written and verbal communication skills Ability to work within and in support of a team environment
Required Technical Qualifications:
2-5 years relevant experience as a production support database administrator in an Oracle and/or SQL Server environment Experience administering Oracle 11g, 12c, 18c or 19c instances/databases Experience administering SQL Server 2008-2019 instances/databases Experience with common database monitoring, diagnostic, trending and administration tools (ex. Toad, DBArtisan, OEM, Solarwinds, etc.) Experience working with Linux operating systems (RedHat) Experience working with Windows operating systems Bachelor's Degree (BS/BA) or equivalent combination of education and experience
Bonus Technical Qualifications:
Experience with Azure Cloud technologies (Azure SQL Server, Azure Analysis Services, Azure Synapse, Azure DataFactory, Azure Active Directory) Experience with Oracle RAC, DataGuard, ASM/ACFS technologies Experience with database instance tuning (memory configuration) Experience with SQL query tuning (baselines, profiles, indexes, explain plans, etc.) Experience with Oracle Database Appliance (ODA) hardware/support Experience with MSSQL Replication, AlwaysOn technologies
Experience with Qlik/Attunity Replicate software or other 3rd-party replication applications

We are currently seeking an Application DBA to join our Next Generation Engineering Identity Governance team. This person will need broad exposure to multiple technologies to assemble the right solution to a challenging problem. Integration projects are complex and involve collaboration from multiple teams, on different time schedules.

We are a progressive development team within the firm working on technology at a scale that is seldom found elsewhere in the world. We use agile methodologies in our development practices and believe that great software is developed through ongoing thoughtful conversation as opposed to a big upfront design. We are building a technically diverse ecosystem using a mixture of vendor products and custom in house built solutions. There will be a focus on Relational, Graph and NoSQL databases. We're looking for true technologists who are driven by the desire to learn and push the boundaries of technology.
The Role:


This will require an understanding of requirements, operating models, business flows and data and then partnering with technical specialists to deliver appropriate solutions. There is an implicit ownership and accountability for the solution working as intended. The ideal candidate is a results-oriented hands-on leader who is responsible for:

Oracle Database administration, query optimization / Schema design and build, ownership of the database environment. Participate in design sessions with fellow programmers, business analysts and team members to analyze business requirements and outline the proposed IT solution. Review designs and provide input to the design recommendations; incorporate security requirements into design; and provide input to information/data flow, and understand and comply with Project Life Cycle Methodology in all planning steps. Document the detailed application specifications, translate technical requirements into programmed application modules and develop/enhance software application modules. Collaborate with fellow developers in design sessions ensuring that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation.



Qualifications:


Bachelor's degree in Information Science / Information Technology, Computer Science, Engineering, Mathematics, Physics, or a related field 5+ years' experience in database administration, tuning and optimization Programming Languages & Tools Languages: SQL, PL/SQL Development Languages: Java, C#, and/or Python Source Control: GIT Patterns: MVC, Web Services, REST Automated Deployment tools Automated Testing tools Continuous Integration tools Test scripts definition and testing experience. Experience with Oracle EXADATA a strong Plus Experience with Oracle 12C a strong plus Databases/Data Processing Relational DB: Oracle (11g). Oracle 11g NoSQL Graph databases Platforms & Services Linux / UNIX: Ubuntu, Red Hat Enterprise Linux



Experience with Agile methodologies including Kanban, Scrum and DevOps. Experience with system design and architecture. Cloud experience preferred. Ability to learn new skills and knowledge to keep up with the changing technology field. Ability to work with project cycles and manage rapid changes. Ability to be flexible and adapt to any given situation. Excellent customer service attitude, communication s (written and verbal), and interpersonal skills Excellent analytical/problem-solving skills to make timely and sound decisions. Ability to work independently and in a team based environment.


JPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.

The health and safety of our colleagues, candidates, clients and communities has been a top priority in light of the COVID-19 pandemic. JPMorgan Chase was awarded the "WELL Health-Safety Rating" for all of our 6,200 locations globally based on our operational policies, maintenance protocols, stakeholder engagement and emergency plans to address a post-COVID-19 environment.

As a part of our commitment to health and safety, we have implemented various COVID-related health and safety requirements for our workforce. Employees are expected to follow the Firm's current COVID-19 or other infectious disease health and safety requirements, including local requirements. Requirements include sharing information including your vaccine card in the firm's vaccine record tool, and may include mask wearing. Requirements may change in the future with the evolving public health landscape. JPMorgan Chase will consider accommodation requests as required by applicable law.

Equal Opportunity Employer/Disability/Veterans

We are looking for a cloud migration and modernization database architect to support the enterprise cloud roadmap from a data perspective.

Responsible to support cloud and infrastructure team with database operations in a multi-database engine environment with an emphasis on Microsoft SQL Server, Oracle, and AWS RDS.

In this role, candidate should have impeccable collaboration, communication, and troubleshooting skills, as well as a high level of initiative. In addition, you should be able to recommend and assist in the design of complex data/database architectures for current, short-term, and future states.
Required Skills and Education


Comprehensive backup and restore capabilities including data guard
Collaboration with application, cloud, and infrastructure SMEs on database-related projects and tasks
Support to-be architectures for Oracle and SQL applications and workloads in the cloud
Possess and apply strong skillsets of multi-account cloud database design
Understand database architectures across on-premises, VMware Cloud on AWS, and AWS native environments
Aid operations and maintenance teams in routine tasks relating to performance, STIGs, patching, modernizing, and right-sizing, backups, restorations, migrations, etc.
Maintain oversight of cloud database metrics and statistics
Have experience with both WinServer and RHEL workloads
Can-Do attitude
In-depth experience in database capacity planning, querying, and automation
Support FORCE and government leadership in enterprise roadmap/planning of cloud database architectures


About BAE Systems Intelligence & Security


BAE Systems, Inc. is the U.S. subsidiary of BAE Systems plc, an international defense, aerospace and security company which delivers a full range of products and services for air, land and naval forces, as well as advanced electronics, security, information technology solutions and customer support services. Improving the future and protecting lives is an ambitious mission, but it's what we do at BAE Systems. Working here means using your passion and ingenuity where it counts - defending national security with breakthrough technology, superior products, and intelligence solutions. As you develop the latest technology and defend national security, you will continually hone your skills on a team-making a big impact on a global scale. At BAE Systems, you'll find a rewarding career that truly makes a difference.

Intelligence & Security (I&S), based in McLean, Virginia, designs and delivers advanced defense, intelligence, and security solutions that support the important missions of our customers. Our pride and dedication shows in everything we do-from intelligence analysis, cyber operations and IT expertise to systems development, systems integration, and operations and maintenance services. Knowing that our work enables the U.S. military and government to recognize, manage and defeat threats inspires us to push ourselves and our technologies to new levels.

Our Commitment to Diversity, Equity, and Inclusion:
At BAE Systems, we work hard every day to nurture an inclusive culture where employees are valued and feel like they belong. We are conscious of the need for all employees to see themselves reflected at every level of the company and know that in order to unlock the full potential of our workforce, everyone must feel confident being their best, most sincere self and be equipped to thrive. We provide impactful professional development experiences to our employees and invest in social impact partnerships to uplift communities and drive purposeful change. Here you will find significant opportunities to do meaningful work in an environment intentionally designed to be one where you will learn, grow and belong.


EEO Career Site


Equal Opportunity Employer. Minorities . females . veterans . individuals with disabilities . sexual orientation . gender identity . gender expression