remote - database architect
Posted on: March 18, 2023
remote - database architect.
austin , texas (remote)
posted 6 days ago
$125,000 - $130,000 per year
category computer and mathematical occupations
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
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.
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.
-Knowledge of Microsoft SQL Server Standard and Enterprise Editions
-Knowledge of SQL Reporting Services and SQL Server Integration Services
-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
Reporting and other BI tools
High Availability database architectures and encryption-at-rest configurations
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 HRsupport@randstadusa.com.
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.
remote - database architect.
Keywords: Randstad, Austin , remote - database architect, IT / Software / Systems , Austin, Texas
here to apply!