Database Administrator 2

Raytheon Technologies - Annapolis Junction, MD

Full-time - Mid Level

Annapolis Junction, MD

Computer and Electronic Product Manufacturing

About the position

The Database Engineer at Nightwing plays a crucial role in providing technical expertise for database design, development, implementation, information storage and retrieval, data flow, and analysis. This position involves developing relational and/or Object-Oriented databases, database parser software, and database loading software. The Database Engineer is responsible for projecting long-range requirements for database administration and design, ensuring that the database structure aligns with the overall architecture of the system under development. This includes making trade-offs among data volumes, number of users, logical and physical distribution, response times, retention rules, security, and domain controls. The Database Engineer primarily works at the front end of the lifecycle, from requirements gathering through system acceptance testing and Initial Operational Capability (IOC). They develop requirements from a project's inception to its conclusion for specific business and Information Technology (IT) subject matter areas, which can range from simple to complex systems. The role also involves assisting with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. The Database Engineer translates a set of requirements and data into usable documents by creating or recreating ad hoc queries, scripts, and macros, updating existing queries, and building complex systems using queries, tables, Open Database Connectivity, and database storage and retrieval using Cloud methodologies.

Responsibilities

• Provide technical expertise for database design, development, implementation, information storage and retrieval, data flow, and analysis.
• Develop relational and/or Object-Oriented databases, database parser software, and database loading software.
• Project long-range requirements for database administration and design.
• Develop a database structure that fits into the overall architecture of the system under development.
• Make trade-offs among data volumes, number of users, logical and physical distribution, response times, retention rules, security, and domain controls.
• Work primarily at the front end of the lifecycle from requirements through system acceptance testing and Initial Operational Capability (IOC).
• Develop requirements from a project's inception to its conclusion for a particular business and IT subject matter area.
• Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts.
• Translate a set of requirements and data into usable documents by creating or recreating ad hoc queries, scripts, and macros.
• Update existing queries, create new ones to manipulate data into a master file, and build complex systems using queries, tables, Open Database Connectivity, and database storage and retrieval using Cloud methodologies.

Requirements

• Ten (10) years of experience as a Database Administrator on programs and contracts of similar scope, type, and complexity.
• Bachelor's degree in a technical discipline from an accredited college or university, or four (4) years of database administration experience may be substituted for a bachelor's degree.
• Maintain the integrity, security, and availability of database(s).
• Establish and maintain database user accounts.
• Administer, maintain, and implement policies and procedures for ensuring the security and integrity of database(s).
• Organize and format data for efficient query and storage processes.
• Evaluate requirements and recommend available DBMS products.
• Provide server administration with a variety of database products that include Oracle, SQL Server, and SYBASE.
• Perform disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data.
• Develop policies and procedures for ensuring the security and integrity of database(s).
• Perform database and software life-cycle activities to ensure the highest level of system performance and availability.
• Support data modeling activities by way of prototype database implementations.
• Coordinate database architecture changes with Database Engineers (DBEs).
• Direct the monitoring, administrating, and implementing performance on database systems as well as database performance optimization.

Nice-to-haves

• Experience with MongoDB and Postgres.

Benefits

• Parental (including paternal) leave
• Flexible work schedules
• Achievement awards
• Educational assistance
• Child/adult backup care
• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Short-term disability
• Long-term disability
• 401(k) match
• Flexible spending accounts
• Employee assistance program
• Employee Scholar Program
• Paid time off
• Holidays