Sr. Database Administrator

Role Overview:
Looking for a passionate and talented individual to join our dynamic team in the role of Senior Database Administrator. This pivotal position will play a key role in shaping the future of our technology stack and driving the expansion of our current applications. As part of our agile development team, we are seeking a self-motivated Senior Database Administrator who excels at creative problem solving, possesses effective communication skills, and thrives on collaboration with team members. Your primary responsibility will be to support and manage the production enterprise-wide databases. You will be handling the installation, configuration and upgrade of database server software and related products. You will be entrusted to maintain backup and recovery plans, handle database security, and perform capacity planning. This person will also help build and maintain different ETL tools and packages to support our different company data flow/models. A motivated team player with a strong background in database administration, both in production and development support is required.
Role Responsibilities

• Manage high volume databases within clustered environments and spanning across many companies
• Knowledge of database security management practices, including access controls, and encryption
• Diagnosis long running applications on the database level and perform corrective action with the use of both SQL Server native and third party performance tools
• Create Heterogeneous replication strategies using native SQL Server replication, ETL, and cloud tools
• Develop custom code, reports, and other data related tasks
• Testing and Installation of new software
• Create stored procedures, triggers and user defined functions and simple to complex DTS/SSIS packages in support of our data strategy goals and dev teams (data development/engineering work)
• Create Entity Relationship Diagrams for developers and management staff
• Import & export data to and from SQL server using ETL tools as well as native SQL and flat files (Excel)
• Performance tune databases in development, test & production environments
• Plan & migrate onprem SQL environments to the cloud (Azure)
• Participate in the resolution of complex design and implementation issues across projects

Experience

• 5+ years of direct experience as a Database Administrator
• 3+ years experience in utilizing SSMS, SSRS, SSIS
• SQL Server Reporting Service (SSRS)
• Reporting knowledge such as PowerBI, Domo, or Tableau
• Understanding of how to administer SQL servers within Azure & managing Azure data factory
• Strong desire to keep data integrity within the different systems and perform necessary backup/restores
• Experience with .Net, C# and other structured languages
• Deep knowledge of underlying network and protocols
• Must have strong communication skills
• Expert level understanding of current marketplace standards, technologies / trends and apply knowledge to user experience solutions
• Highly motivated independent thinker
• Ability to work closely with other teams and share best practices
• Knowledge of SQL for database management and T-SQL for Microsoft SQL Server

Preferred Skills

• Demonstrates proficiency with physical and logical database design
• Can write and understand technical and functional design requirements
• Basic understanding of machine learning models, algorithms, and data processing techniques. Knowledge of how to apply AI/ML, aid in predictive analytics, automation, & optimizing database operations
• Ability to integrate AI/ML models into database environments to enhance capabilities such as predictive maintenance, anomaly detection in data, and automation of routine tasks
• Understanding of other database technologies such as MongoDB, Snowflake, Cassandra, etc.