AustinRecruiter Since 2001
the smart solution for Austin jobs

remote - database architect

Company: Randstad
Location: Austin
Posted on: March 19, 2023

Job Description:

remote - database architect.

  • austin , texas (remote)

  • posted 7 days ago

    job details

    • $125,000 - $130,000 per year

    • permanent

    • bachelor degree

    • category computer and mathematical occupations

    • reference999647

      job details
      job summary:
      Working as a senior member of the design team, the Database Architect is responsible for the design, development, and maintenance of a high transaction performant database system used in our client's Management System. The Database Architect will ensure design coupling between the application and database layers to provide a highly performant data solution when it matters most: end-user registration, absentee management, and other management-related tasks. Using SQL Server, SQL Reporting Services, and SQL Server Integration Services, the architect will ensure the web-based application suite is able to provide data solutions, database maintenance, archiving solutions, and most importantly, highly responsive data analytics and reporting.
      location: Austin, Texas
      job type: Permanent
      salary: $125,000 - 130,000 per year
      work hours: 8am to 5pm
      education: Bachelors

      • Design and implement database architecture for a web-based application to scale to millions of registered voters

      • Design database scalability solutions for applications that require both high transactional processing and large system reports and analytics, optimizing T-SQL queries for highly performant reporting services

      • Determine best practices for database administration of on-premise and cloud-based systems

      • Work with the architecture team to design data schemas that translate into business domain entities - Assist software domain engineers with query tuning for stored procedures, ORM generated

        queries, and best practices in data storage, including SQL vs. no-SQL options for data retention - Create thorough documentation describing system schemas and outlining data flow across the application suite.

        • Determine and document maintainability best practices for database script creation, database deployment, and ongoing data life cycle maintenance (transaction logs, backup/restore, index management, etc.)


          • Bachelor of Science degree in Computer Science or equivalent combination of technical education and experience

            Required Experience

            • Ten years of experience with relational database systems, seven of which use SQL Server

            • Experience designing data schemas for OLTP and OLAP systems, including requirements for scale-up and scale-out solutions in web-based transactional environments.

            • Experience transforming OLTP data schemas into OLAP data schemas in real time

            • Experience with the full software development life cycle and environment management

            • Knowledge of database hardware scalability best practices

            • Experience in developing processes and procedures for database maintenance activities including index management, log analysis, corruption checking, and backup/recovery methods

            • Development of monitoring and alerting methods and processes for proactive notification of data-related issues

            • Proven work history of completing projects on time and on budget, exceeding quality goals

            • Experience working with software engineers and making software/database tradeoffs.

              Required Skills
              -Knowledge of Microsoft SQL Server Standard and Enterprise Editions
              -Knowledge of SQL Reporting Services and SQL Server Integration Services

              • Knowledge of T-SQL and programmability features of SQL Server

                -Knowledge of concurrency with consideration towards page, table, and row locking and transactional impact on table data modifications

                • Ability to troubleshoot an existing database, redesign it, work with developers and QA teams while implementing the change, and integrate it into a production environment

                • Ability to design data storage structures and models that meet the required data workload

                • Ability to take a database from a small scale to a much larger scale while increasing performance

                • Apply problem-solving, analytical, and debugging skills

                • Possess database change management skills in a production environment including ing database updates from Microsoft

                • Ability to collaborate and solid track record of excellent, effective delivery and customer service. Must be able to thrive while constantly on the critical path

                • Must be an effective written and spoken communicator with staff and company management

                • Detail-oriented, organized, thorough and respectful of quality control

                  Desired Skills and Experience:

                  • .Net Framework / C#

                  • Entity Framework or other object-relational mappers

                  • Git, Microsoft DevOps, or other software versioning tools

                  • Data Warehousing

                  • Reporting and other BI tools

                  • High Availability database architectures and encryption-at-rest configurations

                  • Disaster Recovery


                    • Experience level: Experienced

                    • Minimum 10 years of experience

                    • Education: Bachelors (required)


                      • SQL Server (10 years of experience is required)

                      • SQL (7 years of experience is required)

                      • T-SQL (10 years of experience is preferred)

                      • OLTP and OLAP Systems (7 years of experience is preferred)

                      • .NET (7 years of experience is preferred)

                      • C# (7 years of experience is preferred)

                      • Microsoft DevOps (7 years of experience is preferred)

                      • Git (5 years of experience is preferred)

                      • Reporting (7 years of experience is preferred)

                      • encryption-at-rest config. (7 years of experience is preferred)

                      • Disaster Recovery (7 years of experience is preferred)

                        Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
                        At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact
                        Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
                        For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

Keywords: Randstad, Austin , remote - database architect, IT / Software / Systems , Austin, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

Austin RSS job feeds