Job Closed

This listing is no longer active.

RESPEC logo
RESPEC

Achieving the impossible. Transforming our clients' visions into reality.

SQL Server Database Administrator

Database AdministratorDatabase AdministratorOtherRemoteLeadTeam 201-500H1B SponsorCompany SiteLinkedIn

Location

New Mexico

Posted

82 days ago

Salary

0

Seniority

Lead

Bachelor Degree7 yrs expEnglishSQL

Job Description

SQL Server Database Administrator

RESPEC

• Maintain, develop, refactor, and optimize a T-SQL codebase (queries, views, stored procedures, functions) across all OBMS modules. • Perform query tuning, indexing, and performance diagnostics as needed and as appropriate for a large and complex database. • Design, develop, maintain and deploy SSRS reports, ensuring high standards for data accuracy and presentation to non-technical clients. • Partner with the client and other RESPEC consultants on the OBMS team to elicit business requirements and transform them into database design. • Work tickets triaged by a help desk; manage priorities and communicate status/risks clearly. • Contribute to database design patterns for new/enhanced modules, looking for opportunities to evolve or leverage the system's existing architecture where appropriate. • Document changes, follow proper change management processes, and uphold best practices for multi-environment migrations.

Job Requirements

  • 7-10+ years with hands-on SQL Server experience in production environments with a heavy emphasis on stored procedure usage.
  • Proven expertise in query tuning and performance optimization for large, complex databases (e.g. execution plan analysis, indexing strategies).
  • Experience in the full SSRS development lifecycle, from design of the queries used, to the report, to deployment.
  • Strong consulting orientation with the ability to effectively communicate to both technical team members and non-technical clients/stakeholders.
  • A seasoned professional capable of navigating a large codebase and dealing with a steep learning curve.

Benefits

  • Flexible Work Schedules
  • Paid Parental Leave
  • 401(k) & ESOP (with company match up to 4%)
  • Professional Development and Training
  • Tuition Reimbursement
  • Employee Assistance Program
  • Medical/Dental/Vision Insurance Plans

Related Categories

Related Job Pages

More Database Administrator Jobs

ICF logo

Senior Database Administrator (Top Secret cleared)

ICF

Founded in 1969, ICF is a global advisory and technology services company headquartered in Reston, Virginia. It delivers data-driven solutions across energy, environment, infrastru

Description Please note: This role is contingent upon a contract award. While it is not an immediate opening, we are actively conducting interviews and extending offers in anticipation of the award. The Work: ICF is seeking an experienced and driven Software Engineer to lead and oversee mission-critical initiatives in support of the Defense Counterintelligence and Security Agency (DCSA). In this role, you will design, develop, and maintain applications leveraging technologies such as Java, Kotlin, and TypeScript, working across Oracle and SQL Server databases in cloud-hosted environments including AWS GovCloud. Job Location: This position will be remote and requires that the job be performed in the United States.  If you accept this position, you should note that ICF does monitor employee work locations and blocks access from foreign locations/foreign IP addresses, and also prohibits personal VPN connections. You may be asked to travel once a quarter to an office or client site. Our core work hours are 8am - 5pm Eastern Time with the option to start earlier or work later depending on your time zone. What You Will Do: - Participate in all phases of the Software Development Lifecycle (SDLC), including requirements analysis, design, development, testing, deployment, and sustainment of secure, mission-critical applications. - Design, develop, and maintain applications using technologies such as Java, Kotlin, and TypeScript, ensuring scalability, performance, and maintainability. - Develop and optimize database solutions leveraging Oracle and Microsoft SQL Server, ensuring data integrity, performance, and security. - Build and support cloud-based solutions within AWS GovCloud environments, troubleshooting and resolving issues related to cloud services and system integrations. - Collaborate within an Agile development environment, working closely with product owners, architects, cybersecurity, and DevSecOps teams to translate requirements into high-quality software solutions. - Conduct code reviews, unit and integration testing, and debugging activities to ensure applications meet quality, security, and compliance standards. - Create and maintain technical documentation to accurately reflect system architecture, software design, and implementation details. - Ensure compliance with federal regulations, DoW policies, and security requirements.. - Prepare and deliver executive-level briefings, status reports, and performance updates to government stakeholders and corporate leadership. - Maintain a positive, results-oriented work environment by building partnerships with internal and external partners. What You Will Bring With You: - Active Top Secret Clearance  - Proven experience (8+ years or adjust as needed) supporting the full Software Development Lifecycle (SDLC), including design, development, testing, and deployment of secure, enterprise-level applications. What We Would Like You To Bring With You: - Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related technical field. - Experience working with DCSA - 5 years’ supporting applications in AWS GovCloud or other secure cloud environments, with understanding of cloud architecture, performance optimization, and troubleshooting. - Hands-on experience developing applications using Java or Kotlin, and TypeScript, with strong understanding of object-oriented design principles and modern development frameworks. - Experience working with Oracle and/or Microsoft SQL Server databases, including writing and optimizing queries and ensuring data integrity. - Familiarity with Agile methodologies and collaborative development practices, including code reviews, version control, and CI/CD pipelines. - Ability to self-organize, priorities and conduct research on multiple projects under tight deadlines in a fast-paced environment. Professional Skills: - Highly effective analytical, problem-solving, and decision-making capabilities. - Excellent communication and interpersonal skills to interface effectively at all levels of the business. #DMX-HES #Li-cc1 #Indeed Working at ICF ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy. We will consider for employment qualified applicants with arrest and conviction records. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email Candidateaccommodation@icf.com and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.  Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. Candidate AI Usage Policy At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.  However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.   Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position based on full-time employment is: $130,687.00 - $222,169.00 DC Remote Office (DC99)

United States
$130K - $222K / year
Business Wire logo

Senior Applications Database Administrator

Business Wire

Global Leader in News Content Distribution

OtherRemoteTeam 501-1,000Since 1961H1B No Sponsor

Business Wire, a Berkshire Hathaway company, is the global market leader in press release distribution and regulatory disclosure. We are on a mission to redefine how organizations connect with their audiences - and that’s just the beginning! Organizations, large and small, depend on us to accurately publicize market-moving news and multimedia, and generate social engagements that develop interactions with their target audiences. About the Role The Senior Applications Database Administrator will work closely with the Engineering, Architecture, and Operations teams building and supporting our mission-critical database systems as Business Wire undertakes a digital transformation journey. As a member of the DBA team, you will be responsible for defining and supporting new and existing database systems across public cloud and traditional data centers. You will help guide best practices in database administration, data high availability, database management, database design, process improvement, requirements analysis, and the introduction of innovation with a focus on automation. What You'll Do - Manage the full database lifecycle: initial installation and configuration of database technologies, deployment of engineered system design solutions, daily operations, administration, upgrades, and management of database technologies - Provide high-end technical DBA support within a variety of Operating Environments (OE) while also supporting/assisting software development and operational teams with database definition, structure, long-range requirements, operational guidelines, and security/integrity controls according to industry best practices - Propose and implement enhancements to improve performance and reliability within the supported IT environments - Install, configure, upgrade, and patch Oracle EBS environments including both database and application tiers - Manage EBS concurrent managers, workflows, and patch application - Troubleshoot and resolve issues across database and application tiers - Provide subject matter expertise in performance tuning and administration. Analyze and tune SQL and Oracle EBS - Perform DDL code reviews and application code reviews for functionality related to a database - Independently analyze, solve, and correct issues in real time, providing problem resolution - Work closely with L1/L2/L3 support teams to proactively identify and resolve issues - Participate in 24x7 on-call rotation What You'll Need - 7+ years of hands-on Oracle and MySQL database experience in a mission critical 24x7 environment - Proven experience managing Oracle EBS environments including installation, patching, cloning, and performance tuning - Experience working in an Agile/Scrum environment with an understanding of ITIL - Experience with full database lifecycle management: upgrades, patching, cloning, backups, and recovery - Experience with automated database deployment using Jenkins, Ansible, or similar tools - Understanding of Unix operating systems Nice to Have - 4+ years of AWS experience designing and supporting hyper-scale mission critical database architecture - 2+ years proficiency in writing, profiling, and optimizing SQL queries for performance - 2+ years experience creating and maintaining Entity Relationship Diagrams - Understanding of data warehouses, data marts, data lakes, modeling, and profiling - Strong understanding of Java and other development frameworks Business Wire will not sponsor a new applicant for employment authorization for this position. What We Offer The base salary range for this position is $150K to $165K/year. Offered salary will be determined by several factors, including but not limited to: applicant’s education, experience, knowledge, skills and abilities, as well as internal equity and alignment with geographic market data. Business Wire reserves the right to modify this salary range at any time. Business Wire’s total rewards include: - Ability to work remotely - Excellent health benefits that begin on your first day of employment - $100 monthly fitness allotment, a tuition reimbursement program, and enhanced mental health resources - 401(k) plan with generous company match, and annual profit sharing contribution (subject to company performance) - PTO, Floating Holidays, Wellness Day Off, Birthday Day Off, and more! A pre-employment background check will be required after the acceptance of an offer. Business Wire is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. Pursuant to the San Francisco Fair Chance Ordinance and other similar state laws and local ordinances, and its internal policy, Business Wire will also consider for employment qualified applicants with arrest and conviction records.

United States
$150K - $165K / year
Job Closed
OtherRemoteTeam 1,372Since 2022

Who we are: Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow. We are proud to employ and support military veterans who bring mission-first mindset, technical expertise, and leadership qualities that strengthen our work. Veterans, transitioning service members, and military spouses are strongly encouraged to apply. Job Description: We are seeking a Lead Application DBA / Developer (PostgreSQL) to join Softrams' Health IT practice in support of database engineering and administration efforts for a mission-critical federal health program. This role contributes to the reliability, performance, and scalability of production database environments powering modern, responsive web applications for government clients. Basic Requirements: - 12 years of total databse engineering expereince and a Bachelor's degree (BS) in Computer Science, Information Technology, or related field - Active AWS Certification - 7+ years of hands-on experience with PostgreSQL database administration, performance tuning, and production support in high-volume, customer-facing environments - Experience with AWS RDS Aurora PostgreSQL - 5= years of strong PL/pgSQL or PL/SQL experience - Experience with complex, high-volume data warehouse projects - Data modeling experience using ErWin - 3+ yeasrs of experience working in Agile/Scrum large-scale programs - Excellent written, verbal, and interpersonal communication skills - Strong time management skills with the ability to quickly triage and escalate issues - Strong attention to detail and a focus on task completion Additional Qualifications: - Experience working with multi-disciplinary development teams - SAFe (Scaled Agile Framework) experience - Familiarity with DB2 and Oracle database engines - Working experience with z/OS DB2 database Responsibilities: - Maintain and administer production, test, and development PostgreSQL databases - Support development teams from a database design and development perspective - Ensure optimal performance on PostgreSQL environments through proactive tuning and monitoring - Oversee installation, maintenance, configuration, and integrity of PostgreSQL architecture - Perform SQL and PL/pgSQL performance tuning; provide best practice recommendations to application developers - Conduct regular code reviews with application developers - Design, implement, and maintain new databases including backup, recovery, and configuration management - Ensure long-term database systems planning aligns with organizational operations and administration needs - Perform data refresh activities and support across one or more cross-functional teams Why Tria? What defines the Tria brand is more than just our dedication to excellence in our craft; it’s our incredible team of dedicated, talented, and passionate people that make Tria so exceptional. As people powering possible, we are all partners in our team’s shared success. As a company that cares about people, we seek to cultivate a culture in which all can thrive personally and professionally. We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life. At Tria, we are growth-minded, entrepreneurial in spirit, and committed to fostering a culture of inclusion and opportunity for all. Whatever your background, your role, your department, or stage in your professional journey, here you will have opportunities to learn new skills, seize new challenges, and advance your career as we grow. California Consumer Privacy Act (CCPA) We are committed to protecting your privacy. As part of our compliance with the California Consumer Privacy Act (CCPA), we want to inform you about how we collect, use, and protect your personal information during the job application process. For more details, please review https://www.oag.ca.gov/privacy/ccpa.

United States
Job Closed

Senior GIS & Database Engineer - CIMS

Trilon Group

Trilon Group provides smart and sustainable infrastructure solutions across transportation, water, energy, environment, and community sectors. The firm offers a

Senior GIS & Database Engineer - CIMS Department: Construction Management Employment Type: Full Time Location: Remote- USA Description The CIMS (Construction Information Management System) team is seeking a Senior GIS & Database Engineer to support a GIS-based construction data platform used for inspection, testing, and project management workflows. This role combines enterprise GIS administration with professional database management. The position supports a production system built on spatial and non-spatial relational data, web services, and mobile workflows. The successful candidate will demonstrate strong technical capability, sound database practices, and effective collaboration within a highly technical team. What are the core responsibilities for the role? - Administer and maintain enterprise GIS environments - Manage spatial and non-spatial relational databases (PostgreSQL-based) - Design and maintain ETL workflows for spatial and tabular data - Develop database schemas, relationships, and constraints - Monitor and optimize database performance (queries, indexing) - Implement backup, recovery, and data integrity procedures - Publish and maintain GIS services for web and mobile use - Support offline data collection and synchronization workflows - Troubleshoot system performance and data reliability issues - Develop automation scripts and custom tools to support operations - Collaborate with software developers and technical staff on system improvements Position Characteristics This is an enterprise systems role rather than a traditional GIS analyst position. The role requires ownership of GIS infrastructure, relational database health, ETL processes, and automation within a production environment. Qualifications, Skills, and Competencies: - Bachelor’s degree in GIS, Computer Science, Engineering, Information Systems, or related field - 5+ years of experience in enterprise GIS, database administration, or geospatial systems support - Experience managing relational databases (PostgreSQL preferred) - Experience with designing and maintaining ETL processes - Experience administering ArcGIS Enterprise or ArcGIS Server - Strong SQL skills, including query optimization - Experience with Python scripting for automation - Experience supporting multi-user production environments - Understanding of data security and database role management Technical Skills – Required - Enterprise geodatabase management - Relational database administration (schema design, normalization, documentation, indexing, constraints, roles) - SQL performance tuning - ETL design and data transformation workflows - ArcGIS Server administration - Backup and recovery procedures - Sync-enabled/mobile GIS workflows - Cloud-hosted systems (AWS or similar) Technical Skills – Preferred - Experience performing core DBA functions (performance monitoring, storage planning) - Experience developing custom automation tools or database scripts - Familiarity with Linux environments - Experience supporting production systems with uptime expectations - Basic understanding of civil design concepts and terminology. Interpersonal Requirements - Ability to work effectively within a highly technical team - Clear communication with developers and technical stakeholders - Strong troubleshooting and analytical mindset - Professional judgment in balancing technical standards with operational needs - Ability to work independently while contributing to a collaborative environment Why would a candidate want this job? At Horrocks, you can expect a competitive base salary and award-winning benefits. Including, but not limited to: - Medical, dental, vision, life, and disability insurance - Generous paid time off - 401(k): 50% match of contribution up to 6% - Professional development opportunities including in-house training - Paid professional organization membership and professional licensure For more information, visit our website at www.horrocks.com Equal Opportunity Employer including disability and protected veteran status #LI-KG1

United States
Job Closed