Virtuous Tek - McKinney, TX
posted 3 months ago
The Database Administrator position at Virtuous Tek Inc involves a comprehensive role in architecting, designing, implementing, and supporting cloud-based database infrastructure. The successful candidate will work on large and complex database and application deployment projects, including migration, patching, consolidation, and upgrades. A significant aspect of the role includes migrating databases and schema objects from on-premises environments to cloud environments, specifically utilizing AWS services such as RDS and EC2. The position requires expertise in installing, configuring, and upgrading SQL Server and PostgreSQL Aurora, with a focus on using Terraform and CI/CD pipelines to streamline these processes. In addition to the technical responsibilities, the role also involves automating database and schema refreshes using shell scripting or Python. The candidate will be expected to work with monitoring tools such as New Relic or Foglight, setting up alerts and dashboards for RDS instances to ensure optimal performance and reliability. The development of complex database objects, including stored procedures, functions, packages, and triggers using SQL and T-SQL, is also a key responsibility. The position is structured to work under supervision, and candidates should be prepared for travel and/or relocation to unanticipated client sites across the USA as required. This role is ideal for individuals with a strong background in database management and cloud technologies, particularly those who have experience with SQL Server, SSIS, AWS, and SSRS. The position offers an opportunity to engage in significant projects that impact the organization and its clients, making it a vital role within the company.