Role Description JPI is seeking a database administrator (DBA) to assist the U.S. Coast Guard with large-scale government-wide database management for pay and personnel programs. The Functional Consultant will be a member of a team providing system upgrades, implementation and deployment, and maintenance to a federal client. The successful candidate will have: - At least 6 years of experience with a B.A./B.S. degree or 5 years of experience with a master’s degree. - Experience supporting database updates, implementations, automation for business process improvement, and interacting with high-level federal clients. - Thought leadership, critical thinking, and clear written and oral communication skills. - Ability to work effectively independently and in team settings, including close collaboration with program managers and client personnel. Responsibilities Include - Assist with day-to-day functions, queries, and data calls. - Conduct comparative analysis of data output system to ensure accuracy. - Debug any function errors and provide fixes accordingly. - Make recommendations for streamlining current and new program processes. - Maintain database structures and remove redundancies to reduce or eliminate the need for future restructuring due to outside changes as much as possible. - Maintain and develop user guides for existing databases. - Maintain all system and database permissions. - Perform ad hoc queries and VBA code base changes to match any changes from data sources to complete data processing requirements. - Perform end user reports and systems functions as needed. - Perform regular error reporting and regular data integrity checks. - Process backlogged data process items to ensure items are addressed. - Provide input on risk and issue tracking and mitigation strategies. - Provide guidance and direction in the fielding of common software of client’s network. - Test and document performance (time) efficiencies gained over the course of the development process. Qualifications - BA/BS with 6 years of experience or master’s degree with 5 years of experience. - Active Public Trust Clearance. - Proficiency in the following Microsoft applications: Word, Excel, PowerPoint, Outlook, One Note, Project, Visio, Teams, PowerBI. - Experience using MS Access, SQL (Jet SQL and TSQL), and VBA programming. - Experience with the Extract, Transform and Load (ETL) process. - Experience in Database Architecture. - Comfortable communicating with a range of stakeholders both orally and in email. - Experience building and maintaining a trusting relationship with the client and prioritizing demands. - Must be a self-starter with the ability to work effectively independently. - Proven ability to support and coordinate multiple projects simultaneously in a deadline driven process. - Ability to work remotely as needed at USCG HQ. Preferred Experience - Relevant experience in direct support of the US Coast Guard, Government Agencies supporting defense, Homeland Security. Transferable Skills for Management Consulting - Problem solving and critical thinking. - Thinking ‘two steps ahead’ and being prepared for what the client will need next. - Taking initiative vs. waiting to be told what to do. - Managing multiple tasks and prioritizing according to importance. - Flexibility to pivot and adapt to changes in direction of new things. - Considering the details and ensuring accuracy in the small things. - Building rapport with colleagues and clients. Developing a reputation as someone who is responsive and trustworthy. Company Description JPI is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Role Description Profissional Especialista em Banco de Dados com grande experiência em SQL, bem como Cloud AWS e Devops. - Analisar objetos de banco de dados em ambiente legado, entendendo regras de negócio e fluxos técnicos implementados em SQL, procedures, functions, triggers e views. - Mapear dependências entre tabelas, views, procedures, functions, triggers, constraints, índices e demais objetos. - Apoiar a conversão de objetos entre diferentes dialetos SQL (projeto atual: Sybase para SQL Server), identificando incompatibilidades sintáticas, funcionais e comportamentais entre origem e destino. - Validar equivalência funcional dos objetos convertidos e apoiar a criação de scripts de extração, análise, comparação e validação. - Criar e revisar prompts para uso de Inteligência Artificial na análise, conversão e geração de scripts de apoio à migração, sempre com revisão humana e validação técnica. - Apoiar atividades técnicas relacionadas ao ambiente AWS utilizado no projeto. - Documentar impactos, riscos, premissas, decisões técnicas e resultados de validação, colaborando com DBAs, desenvolvedores, analistas e arquitetos. Qualifications - SQL avançado e Microsoft SQL Server - Bancos de dados relacionais, com análise de stored procedures, views, functions, triggers e scripts complexos - Lógica procedural e regras de negócio implementadas no banco de dados - Migração, modernização, conversão ou replatforming de bancos relacionais - Modelagem relacional, constraints, índices, transações, locks e planos de execução - Mapeamento de dependências e validação entre origem e destino - AWS: RDS, EC2, S3, IAM, VPC, CloudWatch - Infrastructure as Code (preferencialmente Terraform) - Python, PowerShell, Shell Script ou outra linguagem para automação - Uso pragmático de IA generativa para análise, conversão e documentação técnica - Criação de prompts estruturados para conversão de SQL, geração de scripts e análise de dependências - Boa documentação técnica e boa comunicação com times técnicos Requirements - Experiência com Sybase ASE - Experiência anterior em migração Sybase para SQL Server - Experiência com engenharia reversa de bancos legados - Experiência em ambientes críticos, transacionais, financeiros ou bancários Benefits - Goste de trabalhar em equipe e seja colaborativa em suas atribuições - Tenha coragem para se desafiar e ir além, abraçando novas oportunidades de crescimento - Transforme ideias em soluções criativas e busque qualidade em toda sua rotina - Tenha habilidades de resolução de problemas - Possua habilidade e se sinta confortável para trabalhar de forma independente e gerenciar o próprio tempo - Tenha interesse em lidar com situações adversas e inovadoras no âmbito tecnológico

Role Description Provide production support, solutions and expertise for Cloud Database Platforms. - Partner with engineering teams, business units to design, develop and deploy AWS Relational, NoSQL and Data Lake architectures. - Ability to troubleshoot difficult issues quickly, deliver RCA and resolve in a 24x7 production environment. - Support performance testing and application benchmarking activities. - Provide recommendations and guidance for improvements of our design. - Collect, monitor and alert on system health metrics. - Ability to work off hours/weekends as required for maintenance. Qualifications - 3+ years of production experience supporting Cloud Database Platforms (Aurora, RDS, DocumentDB, Snowflake). - 5+ years developing critical platform infrastructure. - 8+ years of database development support. - Experience with traditional relational systems; Oracle, SQL Server. - Experience with NoSQL and columnar data stores. - Strong scripting abilities in bash, python. - Experience in version control systems, Git and CI/CD. - Experience in building large systems, distributed systems. - Bachelor's Degree in Computer Science/Engineering, Management Information Systems or equivalent. - Kerberos and Database authentication using key vault. - Knowledge of and experience implementing DevOps principles including Infrastructure-as-code. Requirements - At least 1 recent platform certification or specialty in AWS. - Proven experience building AWS Infrastructure. - Experience in Data Migration Strategies to public cloud.

• Administer and support IDMS databases in IBM z/OS environments. • Monitor, troubleshoot, and optimize IDMS database performance. • Maintain development, testing, staging, and production database environments. • Enable and tune IDMS features to maximize system performance. • Analyze database performance metrics and implement optimization strategies. • Support database deployment, upgrades, and operational procedures. • Design and implement database security and access controls. • Provide technical guidance on database design, modeling, and enhancements. • Collaborate with development, infrastructure, and support teams. • Coordinate with vendors and external stakeholders when required. • Participate in a 24x7 on-call support rotation. • Prepare and maintain technical documentation and operational procedures.