Database Analyst II - DAYS

Full-time - Mid Level

Portsmouth, VA

Accommodation

About the position

The Database Analyst evaluates and reviews U.S State Department database resources and services while ensuring high levels of data quality. These duties can vary within a department and include developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Responsibilities

• Design logical and physical databases, or review a description of changes to the database design to understand the impact to the application and operation.
• Develop and deploy reports and extraction, transformation, and loading process packages to support applications data integration and operation needs.
• Design, develop, and maintain PL/SQL database applications.
• Assist application and web development staff and users on database solutions to business problems; data warehouse architectures; database management system facilities; and capabilities, operation, and tuning of databases.
• Administer, maintain, develop, and implement database security and integrity policies and procedures.
• Perform database and software life-cycle activities to ensure highest level of system performance and availability and compliance with business requirements.
• Perform database backup and monitor scheduled database jobs daily.
• Apply database service patches when necessary to ensure database compliance with regulation and policies.
• Monitor, administer, and implement database systems performance as well as database performance optimization, develop/change database indices, redesign database structure and reload data into a database.
• Coordinate with the system backup team to ensure database is fully backed up and stored in a designated environment.
• Work with business units to convert requirements to database objects, and implement business intelligence reports to meet organization needs.
• Administration and use of current and emerging database tools, strategies, and technologies.
• Evaluate and recommend available database management system (DBMS) products.

Requirements

• Bachelors degree in a related field.
• Three (3) or more years' experience in ORACLE database administration or relevant experience.
• Strong PL/SQL knowledge.
• Oracle Database Administration, Oracle Database SQL, or Oracle Database PL/SQL Developer certified preferred.
• Ability to obtain Secret Clearance.
• U.S. Citizenship.

Benefits

• Tuition Reimbursement program and reduced tuition agreements with Southern New Hampshire University and Great Bay Community College.
• 401(k), health, dental and vision plans, and other insurances you can use.
• An Employee Assistance Plan that's ready when you need it.
• Paid training, paid federal holidays, and paid time off.
• A professional workforce and a mission-oriented environment here to support you and help you grow.
• We are a platinum-level certified New Hampshire Veteran Friendly Business.