Position Summary
Are you the right applicant for this opportunity Find out by reading through the role overview below.
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.
J-18808-Ljbffr
Senior IMS Database Administrator
A company is looking for a Senior IMS Database Administrator to create, maintain, and troubleshoot client databases. ...
Senior Database Administrator
We are seeking a SQL Server Database Administrator to support our SQL Server database systems in test and production environments, both on-premise and in the cloud. As a Senior Database Administrator within our Information Technology Department, your responsibilities include but are not limited to:....
Senior Database Administrator
Database Administrator responsible for providing operational database services. ...
Senior Professional Database Administrator
The Senior Database Administrator will be a creative, analytical, and innovative individual who is passionate about database administration and solutions. Senior Professional Database Administrator. They will be working with other system administrators, developers, database administrators, quality a...
Senior Database Administrator
Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. Minimum of 5 years + experience working as a Database Administrator. Expertise in database administration for large Data warehouse/datamart implementations i...
Senior SQL Database Administrator (DBA) - Remote
The Senior SQL Database Administrator (DBA) leads and works closely on the EIS DBA technology team in designing, installing, maintaining, fix and optimization of SQL Server database instances for departmental and enterprise-wide systems across physical and virtual servers for both on-premises and cl...
Database Administrator (DBA) / Senior Data Engineer
Minimum of four (4) years of experience as a database administrator (DBA). PostgreSQL database administration (DBA) experience:. Monitor and optimize database performance. Database design, security, and architecture experience. ...
Senior Database Administrator
The Senior Database Administrator engages directly with Information Technology and Business stakeholders to ensure the on-time and successful delivery of database services to the organization and development team as defined by the Information Technology Department’s Service Level Agreement. Provide ...
Senior Database Administrator
Implement and maintain database security (create and maintain users and roles, assign privileges), establish procedures to apply most recent Critical Patch Updates to the databases. Evaluation of database features and database related products. Design, Configure and Maintain Oracle, Postgres and MyS...
Senior SQL Database Administrator
Our Los Angeles office is seeking a SQL Database Administrator with expertise in managing diverse database environments, including Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. Manage databases in Azure Cloud environments, including Azure SQL Database, Azure Database for PostgreSQL, an...