We are an employee-centric company that truly appreciates our team members and their value to our customers and the missions they support. We pride ourselves on being forward-leaning thinkers and fostering teams that are and continue to be technically proficient and technically capable across a comprehensive range of cyber mission areas. OneZero full-time employees receive an extremely competitive benefits package that includes health/dental/vision/life insurance plans, 401K with company matching, PTO & paid holidays, employee referral program, and educational assistance. Additional details can be found on our website at: Position Title: Database Analyst Junior Location: Portsmouth, NH Clearance: Secret The Database Analyst Junior is to evaluate and review Dept. of State 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. Design logical and physical databases or reviews description of changes to 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 policies and procedure for ensuring the security and integrity of the database.
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 at daily basis.
Apply database service patch to ensure database compliance with regulation and polices.
Monitor, administer, and implement performance on database systems as well as database performance optimization, develop/change database indices, redesign database structure and reload data into a database.
Coordinate system backup team to ensure database is fully backup and stored at designated environment.
Work with business units to convert requirements to database objects and implement business intelligence reports to meet organization needs.
Administer and use of current and emerging database tools, strategies, and technologies.
Evaluate and recommends available database management system (DBMS) products.
Qualifications Three (3) or more years' experience in ORACLE database administration or relevant experience with strong PL/SQL knowledge. Oracle Database Administration, Oracle Database SQL, or Oracle Database PL/SQL Developer certified preferred. OneZero Solutions, LLC is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability. If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access as a result of your disability. To request an accommodation, please contact us at or call .