Were excited youre considering joining a great place to work! At Texas Mutual, we value our employees. Our service-driven culture, competitive compensation and benefits, award-winning wellness program and excellent career opportunities make Texas Mutual a great place to work.
We're building a stronger, safer Texas. Named one of the Best Companies to Work for in Texas and located in the Mueller development, we offer modern sit/stand workstations, collaboration spaces, a fitness center, and incredible work-life balance.
As the Senior Database Administrator, reporting to the Senior Manager, you will implement and maintain the performance of essential SQL Server RDBMS systems to ensure availability and consistency for enterprise applications. You will be hand-on, showcasing both your solid technical and interpersonal skills. In addition to complex work, you will perform routine database administration tasks and enter data in system admin logs. You will have knowledge of debugging protocols and processes, as well as the ability to troubleshoot issues and implement corrective actions. You will review database performance trends and identify opportunities for improvement.
Responsibilities & Qualifications
In this Role:
- Manage SQL databases in development, QA and production environments
- Resolve all database-related issues
- Monitor databases both from a performance and capacity management perspective
- Perform database maintenance activities such as backup/recovery and rebuilding/reorganizing indexes
- Ensure that all database releases are assessed and measured from a functionality and performance perspective
- Provide technical expertise on all database design (Logical and Physical modelling) and development project
- Demonstrate SQL Development(T-SQL) expertise related to performance tuning of database schema, stored procedures, etc.
- Create and schedule SQL Server agent jobs.
- Set-up and manage fail-over clusters (in partnership with Infrastructure)
- Develop SSIS packages, database mirroring, and replications
- Automate database management activities using PowerShell, SSIS, and other technologies
- Perform system monitoring, metric reporting, and diagnostics
Required Qualifications:
- Bachelors degree in computer science, related field or equivalent combination of education and experience
- At least 7 years of related experience
- Experience with Microsoft SQL Server Clustering, Replication, and Always On
- Experience with database technologies, such as MS SQL Server 2008, 2012, 2014 and above
- Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler or other related tools
- Familiarity with JASON, XML, and .NET framework
- Experience managing large numbers of databases in a real-time production environment
- Experience resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, and data replication issues
- Experience with database maintenance activities such as backup/recovery and capacity monitoring/management
- Knowledge of how indexes work; management of index statistics and fragmentation
- Deep, specialized domain expertise in deployed systems (i.e. distributed systems algorithms, storage allocation algorithms, and deep database skills)
Preferred Qualifications:
- At least 15 years of related experience
- Experience managing and making software deployments/changes in real-time production environments
- Experience collaborating with development teams on logical/physical database design activities and performance tuning
- Knowledge and experience managing DB2 iSeries databases
- Experience supporting Business Applications DB and Data Warehousing/BI platforms
- Familiarity with Data Lakes, Operational Data Stores, Enterprise Data Warehouses
- Experience with cloud technologies
- Experience with MuleSoft Integration platform
- Experience with implementation of Guidewires Data Warehouse products: Datahub and Info Center
- Experience with ETL tools like SAP BODS, SSIS and similar
-
Day one health, dental, and vision insurance
-
Performance bonus
-
401k plan with 4% basic employer contribution and 100% employer match contribution up to 6%
-
Vacation, sick, holiday and volunteer time off
-
Life and disability insurance
-
Flexible spending account
-
Free on-site gym and fitness classes
-
Professional development
-
Tuition reimbursement
-
Pet insurance
-
Free identity theft protection
-
Company-sponsored social and philanthropy events
Texas Mutual Insurance Company is an Equal Employment Opportunity employer.
by via developer jobs - Stack Overflow
No comments:
Post a Comment