The Database Administrator is responsible for managing the SQL Server Enterprise Database management system on the Microsoft Windows Server platform hosted on our physical servers in a 24/7 environment. The Database Administrator (DBA) is responsible for the performance, ongoing maintenance, backup/recovery, security of the database, with an emphasis on data warehousing and data analytics.
Key Responsibilities
• Responsible for maintaining and supporting all Production/Test/Development MS SQL Servers, ensuring that
database code meets company standards for readability, reliability, and performance
• Install and configure new SQL Servers, on physical hardware and virtualized testing environments
• Experience with SQL Server performance optimization, determining the most effective way to increase performance
including server configuration changes or index/query changes
• Proactively identify performance gains (index strategies, TempDB configuration, partitioning, compression, etc.)
• Proficiency in SQL Server High Availability clusters and replication, especially regarding backup/recovery, disaster
recovery, and planning
• Monitor scheduled database and application backups
• Audit/approve change requests to existing tables, stored procedures, indices, constraints, triggers, and views as
well as audit/approve new entries
• Troubleshoot and resolve SQL Server outages as they occur, including after-hours and weekends
• Assist with production system release management, collaborating with Software Configuration Manager and
perations team to plan and execute production releases, and when necessary, coordinate release reversion
• Monitor our production, test and development SQL Servers and keep our system free from errors and outages
24x7x365
• Develop infrastructure to support a revenue-generating data warehouse model using SSIS and other tools
• Clean and prepare data and create pipelines between production databases and the data warehouse database
Qualifications
• Understand complex software engineering principles to be able to discuss with clarity pros/cons of various
design/tool choices
• Multitask, prioritize, show initiative, and respond quickly in a fast-paced environment
• Intellectually curious, with a passion for continuous learning and growing professionally
• Excellent problem-solving and troubleshooting skills
• Ability to quickly respond to critical problems
• Ability to prioritize and adapt in a dynamic environment
• Understand and communicate effectively about problems at hand
• Follow best practices around documentation and troubleshooting
• Ability to summarize the work and communicate status, plan iterative improvements and multitask.
Preferred Experience
• Experience with data warehousing, SSIS, and Microsoft Power BI
• Familiarity with GIT and Red Gate Source Control
• Familiarity with Atlassian products including BitBucket, Jira, and Confluence
• Ability to write and integrate PowerShell scripts
• Experience using SolarWinds Database Performance Analyzer and other monitoring tools
...mentoring, motivating and developing teams. Education: ~ Bachelor's degree or equivalent, MBA preferred. About Us Fortinet (NASDAQ: FTNT) secures the largest enterprise, service provider, and government organizations around the world. Fortinet empowers...
...Team We are looking for compassionate, caring people to join our talented staff of... ...are subject to availability Deaconess RN on Call is available for employees 24/7/36... ...of training to patients who present with urgent, emergent or potential health problems, as...
...eventually be a four day workweek upon another hire in the near future. *Be an intricate part of the team providing care at homeless shelters *Work alongside other clinicians in the field to contact, and build rapport with clients residing in this area *Be positioned...
...We are looking for a Data Entry Clerk to type information into our database from paper documents. The ideal candidate will be computer... ...; Knowledge of touch typing system is strongly preferred Excellent knowledge of word processing tools and spreadsheets (MS Office...
...Desired Qualifications: ~ Working knowledge of central processing procedures and instruments Responsibilities Cleans... ...stores, distributes, and maintains various supplies, equipment and sterilization of instruments and linen to assure the efficient operations.