Position Summary
TCW is investing in multi-year technology and data initiatives, and the Sr. Database Administrator will play an important role in the success of the firm’s data processing. The Sr. Database Administrator will administer and optimize data platforms across our hybrid environment. This includes local SQL Server databases as well as Snowflake and Azure Cloud databases. The incumbent will provide best practices to implement SQL server and Snowflake features, processing, and ETL data movement. General responsibilities will include deploying migrations, ensuring server health, troubleshooting, applying service packs/hot fixes, managing and monitoring server activities/processes, and performing database maintenance tasks. Other responsibilities will include providing developers design guidance, best practices, and design consideration for SQL Server and Snowflake related technologies.
In addition to the administrative duties, the Sr. Database Administrator must be a self-starter in developing process improvement plans and solutions including cloud cost optimization and data resiliency, archiving, and backup strategies across platforms. The role requires a continuous improvement mindset, and the incumbent is expected to perform research and make recommendations on new software, code/software upgrades, and updates to policies and procedures for database code migration, data security management, and disaster recovery planning and implementation.
Essential Duties
- Perform database monitoring and troubleshooting using Solarwinds DPA, Dynatrace, and vendor monitoring tools. Detect and troubleshoot processing, Memory, I/O, space, and other resource contention. Analyze, solve, and correct issues in real time.
- Plan, commission, and deploy Database System changes. Work with Windows OS, Azure, Snowflake, Storage, Network teams to perform database server commissioning, maintenance, problem analysis, and capacity planning for database growth. Perform database server upgrades and applying major services packs.
- Manage and monitor ETL processes (Bryteflow, SQL Server change tracking, SQL Server Replication, DBT).
- Ensure high levels of performance, availability, sustainability, and security. Perform performance tuning and maintenance of more than 100+ SQL Server hosted and Azure instances across production and non-production environments. Make Snowflake performance tuning/recommendations. Assist developers with query tuning and schema refinement.
- Respond to database backup/restore, security/change management, and deployment requests from Developers, Quality Assurance teams, Business Analysts, and end users. Provide suggestions for solutions to Business/Development Teams.
- Refine and automate regular processes, track issues, and document changes.
- Provide 24x7 support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
- Design, implement, and support SQL Server product family and technologies including Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Transact-SQL and batch development, scripting. Perform monitoring and maintenance functions from backup/restore, index rebuild, update statistics, to log and database size monitoring.
Required Qualifications
- Bachelor’s degree in computer science or related field.
- 7+ years working with MS SQL Server 2016 and newer, Snowflake, and Azure SQL as a Database Administrator.
- 7+ years of experience with Performance Tuning and Optimization (PTO).
- Demonstrated project management skills.
- Experience using TFS (or Git*) for code and time-management.
Professional Skills Qualifications
- Strong interpersonal and communication skills.
- Team player with good time-management skills.
Desired Qualifications
- Familiarity with the following technologies/tools is plus: Analysis Service (SSAS), Database warehouse, .NET, Windows scripting languages (PowerShell), Python, Networking, Active Directory, SAN Storage, SQL VMware implementations.
- Experience with Hybrid Cloud migrations and implementations (Azure and Snowflake).
- Snowflake (SnowPro Core, SnowPro SME.
- Azure(Azure Database Admin Assoc, Azure Data Fundamentals.
- MCTS, MCITP, and/or MVP certifications a plus.
- Experience with supporting terabyte and high transaction databases.
- Experience working in the financial services industry.
- Delphix experience is a definite plus.
Estimated Compensation:
Base Salary: For CA based position, the base salary range is $140K-$170K. This is an anticipated range for base salary.
Other Compensation: Eligible to be considered for an annual discretionary bonus
Benefits: Eligible for TCW’s comprehensive benefits package.
#LI-DG1
