Senior Database Administrator- US - Remote

Software Engineering · Pasadena, California
Department Software Engineering
Employment Type Full -Time / Non-Managerial
Minimum Experience Experienced

About Us:

eCivis is the #1 SaaS/Cloud grants management and cost allocation software company, and a part of GTY Holdings, Inc, the leading public sector SaaS company offering a cloud-based suite of solutions for North American state and local governments. eCivis is a mission-driven GovTech leader that helps state, local, and tribal government agencies maximize their grant revenues, track financial and program performance, prepare cost allocation plans and budgets, stay compliant and access free open data tools to better utilize Federal resources. eCivis’ end-to-end SaaS platform brings resources back to state and local government, tribes, and non-profits to improve our communities and make a real impact by helping our clients solve essential grant management challenges.


Summary:
We are seeking a Senior Database Administrator to take on a central role in all aspects of the operations, change management, on multiple relational databases. We are 100% in AWS.

Responsibilities:

  • Managing multiple instances of high transaction Microsoft SQL Servers. All are in RDS.
  • Partner with Software Developers, Engineers, DevOps, Architects, and various other departments to review implementation requests, provide feedback, deploy and maintain these requests.
  • Conduct code review, data/schema comparison, and query optimization by examining execution plan and profiling.
  • Responsible for the overall performance, tuning, and backup/recovery of the SQL instances.
  • Proactive maintenance of all database instances (upgrades, patching, integrity check, security control), during normal business hours, and/or, off-hours to reduce impact to business operations.
  • Implement data retention policies for operational, as well as sensitive data store.
  • Implement, maintain and execute data scrubbing/obfuscation scripts for testing, staging, and production environment.
  • Evaluate, recommend, implement database management and monitoring tools.
  • Design and implement redundant systems for high availability, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets for compliance and audit.
  • Troubleshoot and maintain various scheduled jobs, SSIS Packages for both maintenance, monitoring, and specific business needs.
  • Act as support during release and maintenance windows, as well as through periods of peak seasonal demands.
  • Primarily working with MSSQL but capable and willing to learn to work with other database types outside of MSSQL e.g. Athena, PostgreSQL, Aurora, DynamoDB, other RDS databases in AWS.


Qualifications:

  • Minimum of 5 years of extensive experience in Microsoft SQL Server
  • Bachelor's degree in a technical field preferred
  • Relevant Microsoft SQL Server certifications preferred
  • Proficiency in stored procedures, triggers, views, replication, performance tuning
  • Managing Users and Roles for both business user and a service account to ensure proper access control
  • Technical expertise in database and schema design patterns
  • Prior experience helpful with following compliance and audit requirement (CCPA/GDPR, PII, PCI, SOX, HIPAA, etc)
  • Familiar with a wide range of RDBMS and tools
  • Experience with data reporting tools
  • Ability to maintain composure and learn quickly on the fly
  • Strong time management skills and ability to juggle priorities
  • Ability to be autonomous with minimal supervision.
  • Detail-oriented, organized, thorough, respect for quality control.
  • Strong verbal and written communication

Nice to have:

  • Experience working with AWS (RDS, managed instance)
  • Experience with CICD enterprise practices
  • Experience with DB change and deployment strategies
  • Experience with data modeling
  • Experience working with SSIS Packages, ETL, ELT.
  • Experience interface with third-party integration (with, or without API)
  • Experience with data warehousing
  • Experience with streaming technologies such as Snowflake, Spark, Kafka


Benefits:

  • FlexPTO
  • Health, dental, and vision coverage
  • Fully remote organization
  • Remote work stipend



GTY Business units are committed to providing equal employment opportunities. All qualified applicants and employees will be considered for employment and advancement without regard to race, color, religion, creed, national origin, ancestry, sex, gender, gender identity, gender expression, physical or mental disability, age, genetic information, sexual or affectional orientation, marital status, status concerning public assistance, familial status, military or veteran status or any other status protected by applicable law.

Thank You

Your application was submitted successfully.

  • Location
    Pasadena, California
  • Department
    Software Engineering
  • Employment Type
    Full -Time / Non-Managerial
  • Minimum Experience
    Experienced