What are the responsibilities and job description for the Contract PostgreSQL Database Administrator (SQL Server, SSIS, Postgre SQL) position at S2S Technology Services?
Job Summary:
We are seeking a skilled and innovative 100% onsite Contract PostgreSQL Database Administrator to the State of Nevada government Client. The ideal candidate will have deep expertise in large-scale data migrations, relational database design, and performance tuning, with a track record of working on complex government or enterprise IT projects.
Location: 100% onsite (Carson City, NV)
Client: State of Nevada
Duration: 12 months (Extendable)
Qualifications:
- 10 years of experience in database architecture and administration, with a focus on data migration projects.
- Proven success leading end-to-end data migrations involving multiple systems and large volumes of structured data.
- Expert-level knowledge of Microsoft SQL Server, and modern database platforms (e.g., PostgreSQL, cloud-based DBaaS solutions).
- Hands-on experience with ETL tools (e.g., SSIS, Informatica, Talend) and scripting languages (e.g., T-SQL, PL/SQL, Python).
- Strong understanding of data modeling (OLTP/OLAP), normalization, indexing, and performance tuning.
- Familiarity with state or federal government data environments is highly desirable.
- Experience working in agile and hybrid project environments.
- Excellent communication, leadership, and documentation skills.
Key Responsibilities
- Lead the maintenance, and optimization of legacy SQL Server environments to allow a smooth data transition and transformation between our legacy application into our vendor's solution.
- Develop and maintain the overall data architecture to support modern application workflows, ensuring data integrity, security, and accessibility.
- Create and manage ETL processes and tools for data transformation and transfer.
- Collaborate with development teams, business analysts, and external vendors to align data strategies with business and technical requirements.
- Establish and enforce data governance, quality, and security protocols.
- Conduct data mapping, cleansing, validation, and reconciliation to ensure a smooth transition to the new system.
- Lead efforts to optimize database performance and ensure high availability and disaster recovery.
- Document data flows, models, and architecture diagrams for both legacy and modernized systems.
- Design and implement scalable, secure, and high-performance database architectures to support enterprise applications.
- Act as the subject matter expert on data integration, warehousing, and migration from legacy systems to modern platforms.
- Collaborate with cross-functional teams, including developers, system admins, and business units, to ensure data availability and reliability.
- Develop and enforce database best practices, backup/recovery strategies, and disaster recovery protocols.
- Analyze and troubleshoot complex performance issues at the query, index, and infrastructure level.
- Support modernization efforts and future-proofing initiatives, including cloud readiness assessments and data governance planning.
Preferred Qualifications
- Experience migrating financial or licensing systems (e.g., Great Plains, CRM platforms).
- Knowledge of Nevada’s regulatory, licensing, or business registration processes.
- Experience working with DevOps teams and cloud infrastructure (e.g., Azure, AWS RDS)
Job Type: Contract
Pay: $75,000.00 - $80,000.00 per year
Schedule:
- 8 hour shift
Ability to Commute:
- Carson City, NV 89701 (Preferred)
Ability to Relocate:
- Carson City, NV 89701: Relocate before starting work (Preferred)
Work Location: In person
Salary : $75,000 - $80,000