Database Administrator providing secure SQL Server Database Services for defense and intelligence communities. Engaging in design, implementation, and modernization of database environments.
About the role
- Database Architect and Administrator responsible for designing and managing SQL and NoSQL databases for OPTO Products. Collaborating with teams to ensure optimal database performance and security.
Responsibilities
- Design and implement database architectures for both SQL and NoSQL databases.
- Administer and maintain MS-SQL, PostgreSQL, MongoDB databases.
- Ensure database security, backup, and recovery processes are in place and effective.
- Implement data warehousing best practices to ensure data quality, performance, and scalability.
- Monitor database performance and optimize queries for efficiency.
- Collaborate with development teams to design and implement database solutions that meet business requirements.
- Develop and maintain database documentation, including data models, schemas, and procedures.
- Troubleshoot and resolve database-related issues in a timely manner.
- Conduct regular database performance reviews and provide recommendations for improvements.
- Implement and manage database clustering, replication, and failover strategies to ensure high availability and disaster recovery.
- Develop and enforce database standards, guidelines, and best practices.
- Work closely with the IT security team to ensure compliance with data security policies and regulations.
- Provide technical support and guidance to other team members and stakeholders.
- Design, implement, and test backup, recovery, and disaster recovery procedures with minimal downtime.
- Evaluate and recommend new database technologies and tools to enhance the database infrastructure.
- Manage database access controls and permissions to ensure data integrity and security.
- Perform database migrations and upgrades as needed.
- Create and maintain automated scripts for database maintenance tasks.
- Create and maintain comprehensive documentation for data architecture, ETL processes, and data models.
- Provide training and support to other team members and end-users on data-related best practices and tools.
Requirements
- BS in Computer Science. Masters Preferred.
- 10+ years of experience as a Database Architect and Administrator.
- Strong knowledge of MS-SQL, PostgreSQL, and MongoDB and tools to develop and maintain the databases.
- Self-starter with the ability to investigate and understand business requirements, translate them into technical specifications, and implement the required design.
- Experience with database design, performance tuning, locks, and query optimization
- Experience with database security best practices.
- Experience as a standalone DBA. Willing to work independently, drive critical efforts, and plan and manage work.
- Excellent problem-solving and analytical skills. Strong communication and collaboration skills.
Benefits
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Health Care Concierge Service
- 401(k) Retirement Plan (Pre-tax & Roth)
- Company paid Basic Life Insurance, Short-Term Disability & Long-Term Disability
- Voluntary Life & AD&D Insurance
- Voluntary Accident, Critical Illness & Hospital Indemnity Insurance
- Pet Insurance
- Milk Stork Program
- Wellness Program with gift card redemption and wellness challenges
- Paid Time Off (Vacation, Sick & 10 Holidays)
- Training & Development*****KPI Solutions provides equal employment opportunity to all individuals regardless of their race, color, creed, religion, gender, age, sexual orientation, national origin, disability, veteran status, or any other characteristic protected by states, federal, or local law.*
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Senior Database Administrator designing secure and scalable database environments for international clients. Collaborating with diverse teams to support database infrastructure within Avenga's global operations.
Database Administrator managing production databases for critical systems at Aviture. Ensuring stability and security while aiding modernization efforts in a hybrid work environment.
Senior Database Administrator managing database systems and migrations at Cayuse Civil Services. Leading efforts in database management and performance optimization with a commitment to security standards.
Database Administrator at CIEE, monitoring and optimizing database performance, documenting processes, and managing access security. Working at a philanthropic institution supporting youth employment.
Database Management Architect responsible for system architecture and security management. Configuring, maintaining databases while collaborating with diverse teams in Kyndryl.
Sr. PostgreSQL Database Administrator delivering technical solutions within federal government. Managing databases for mission - critical applications with a high level of responsibility and expertise.
Database Administrator supporting federal client by providing architectural guidance in a SecDevOps environment. Focused on building modern, cloud - native applications and optimizing database systems.
Senior Database Administrator responsible for GCP database services for healthcare systems at BCBST. Involves designing, securing, and automating cloud - native databases, while supporting DB2 LUW.
MS SQL Server DBA III role responsible for operational database services and incident management. Engage with cross - functional teams and databases for optimal solutions.