Database Analyst - Work-from-Home Flexible Portsmouth, NH Work Type: Hybrid

NANA Regional Corporation - Portsmouth, NH

Full-time - Mid Level

Onsite - Portsmouth, NH

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Database Analyst evaluates and reviews U.S State Department database resources and services while ensuring high levels of data quality. This role involves developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. The position requires a strong understanding of database management systems, particularly ORACLE, and the ability to design logical and physical databases. The Database Analyst will also be responsible for developing and deploying reports and ETL (extraction, transformation, and loading) process packages to support application data integration and operational needs. In addition to database design and management, the Database Analyst will assist application and web development staff and users in finding database solutions to business problems. This includes working on data warehouse architectures, database management system facilities, and the operation and tuning of databases. The role also requires administering, maintaining, developing, and implementing database security and integrity policies and procedures. The Database Analyst will perform database and software life-cycle activities to ensure the highest level of system performance and availability, as well as compliance with business requirements. The position offers work-from-home flexibility after training, but candidates must live within 90 miles of the National Visa Center in Portsmouth, New Hampshire. The work environment is mission-oriented, supporting a professional workforce dedicated to growth and development. The company values honesty, integrity, and respect, and is committed to improving the quality of life for its shareholders and communities.

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

• Bachelor's 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.
• U.S. citizenship and ability to obtain and maintain a SECRET-level federal security clearance.
• Successful completion of a criminal and credit background investigation as well as a comprehensive investigation as part of the security clearance process.

Nice-to-haves

• Experience with data warehouse architectures.
• Familiarity with emerging database tools and technologies.

Benefits

• Work-from-home flexibility after training.
• 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.
• Employee Assistance Plan.
• Paid training, paid federal holidays, and paid time off.
• Professional workforce and a mission-oriented environment.