About Us: TCC Solutions is a leading provider of early childhood education and care (ECEC) technology and program services to state and local government agencies for the benefit of children, families, and providers. TCC is a minority-owned business enterprise (MBE) with more than 20 years of experience and 180 team members, including subject matter experts with deep expertise in early childhood business, program, and policy. TCC provides ECEC solutions to state and local agencies nationwide.
Job Summary
Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues.
Essential Functions:
-
Ensures high availability, reliability, and performance of production Server databases
-
Handles capacity planning and scalability of production database platform
-
Sets up automated monitoring, with emphasis on preventative maintenance
-
Installs, configures, and upgrades database server and related products
-
Responsible for replication, backup, and disaster recovery
-
Performs tuning for database, queries and stored procedures
-
Handles data migration between different types of databases
-
Maintain product development knowledge, having familiarity with issues related to database design, data modeling, and schema changes
-
Troubleshoots, resolves issues and documents solutions
-
Assist managing large, high-volume databases
-
SQL Server experience is required (5-7 years)
-
Facilitate change control
-
Performs database migrations outside of normal working hours
-
Performs daily audits of databases
-
Performs data changes as needed by the client
-
SSRS and SSIS deployments
-
Web deployments as necessary
Required Education, Experience, and Skills
-
Bachelor’s Degree in related field
-
Minimum of 7 years relevant experience
-
Familiarity with a variety of the field's concepts, practices, and procedures including expert working knowledge of multiple platforms (for applicable technology):
-
Transactional databases and good knowledge of data warehouses.
-
Underlying operating systems.
-
Logical and physical database design.
-
Server backup and recovery scenarios.
-
Server database, related utilities and tools.
-
Ability to perform both Server and operating systems performance tuning and monitoring.
-
Relies on extensive experience and judgment to plan and accomplish goals.
- Ability to multi-task, and handle multiple projects and deadlines.
-
Performs a variety of complicated tasks.
Preferred Education, Experience, and Skills
-
Master’s Degree in a related field preferred
-
MCSE, MCTS, MCITP