Orion First

The SQL/Azure Database Administrator plays a critical role in overseeing the integration and maintenance of the company's software-based operational systems, ensuring alignment with organizational objectives and regulatory standards.. Reporting to the VP Data and Analytics, DBA collaborates closely with the management team and department representatives to manage existing systems effectively, implement enhancements, and spearhead the development of new tools, demonstrating proficiency in SQL Server, TSQL, Access,.. The ideal candidate will have a strong background in SQL Server database administration, coupled with experience in planning, executing, and managing migrations of on-premises databases to Microsoft Azure cloud environments.. VP Data & Analytics. Implement high availability and disaster recovery solutions for Azure databases, such as Azure SQL Database replication, failover groups, and automated backups.

database administrator

We want to make sure you are aware of something really important. Unfortunately, there are some employment scams out there that you need to watch out for. Keep reading to make sure you stay safe and don't fall victim to these sneaky schemes. Here are some things to watch out for: <ul> <li>All communication during our recruitment and onboarding process will come from Orion HR with emails ending with the domain "@orionfirst.com" </li><li>Make sure to visit our company's official Careers site and fill out an application. </li><li>Orion First will never ask you for money (e.g., visa fees, taxes, travel expenses, etc.) or sensitive personal information (e.g., bank account, social security numbers, passport information, etc.) </li><li>Our recruitment process follows a specific procedure, which involves a series of interviews with the hiring team. The first interview is conducted with the HR team. We rely on Microsoft Teams as our preferred video interviewing platform for all our interviews. </li></ul>OUR COMPANY Committed to the growth of our clients, Orion First appreciates the importance of its own team development. Orion's culture is built around empowering each employee to channel their drive and exercise his or her own judgment, care, and leadership. Our employees are continually leading our industry forward through active roles throughout the industry association's various councils and committees. We work hard to provide motivated and talented individuals an opportunity to achieve their career goals. We cultivate employees that express an earnest desire to learn and grow within the organization, filling new roles as they gain experience. We are always seeking to connect with driven individuals, because we know our growth and success is the result of talented, focused, and persistent hard work. OUR BENEFITS In addition to a salary that is competitive for both the industry and the region, Orion First offers the following benefits and perquisites: <ul><li> Health Insurance </li><li> Dental Insurance </li><li> Vision Insurance </li><li> Time Off </li><li> Retirement </li><li> WFH Benefit </li><li> And More! </li></ul>JOB SUMMARY The SQL/Azure Database Administrator plays a critical role in overseeing the integration and maintenance of the company's software-based operational systems, ensuring alignment with organizational objectives and regulatory standards. Reporting to the VP Data and Analytics, DBA collaborates closely with the management team and department representatives to manage existing systems effectively, implement enhancements, and spearhead the development of new tools, demonstrating proficiency in SQL Server, TSQL, Access, .NET, XML, and agile software development methodologies. The ideal candidate will have a strong background in SQL Server database administration, coupled with experience in planning, executing, and managing migrations of on-premises databases to Microsoft Azure cloud environments. REPORTS TO: VP Data & Analytics KEY RESPONSIBILITIES Database Administration: <ul><li> Manage and administer SQL Server databases (2005, 2008, 2012), including provisioning, configuration, monitoring, and maintenance. </li><li> Perform regular backups, index maintenance, and database optimization to ensure optimal performance. </li><li> Utilize TSQL for scripting and automation of routine tasks. </li><li> Implement security measures and access controls to protect sensitive data. </li></ul>Azure Migration Planning and Execution: <ul><li> Assess existing on-premises databases for migration suitability and compatibility with Azure services. </li><li> Develop migration strategies and roadmaps based on business requirements and technical constraints. </li><li> Execute database migrations to Microsoft Azure, ensuring minimal downtime and data loss. </li><li> Validate migrated databases to ensure functionality, performance, and data integrity. </li></ul>Reporting Services Integration: <ul><li> Utilize SQL Server Reporting Services (SSRS) for generating and delivering interactive, graphical reports. </li><li> Integrate SQL Server databases with SSRS to provide stakeholders with actionable insights and analytics. </li></ul>Application Integration: <ul><li> Work closely with .NET developers to ensure seamless integration of SQL databases with .NET applications. </li><li> Collaborate on database design and optimization to support efficient data access and manipulation. </li></ul>Data Management and Interoperability: <ul><li> Utilize Access for managing and querying relational databases, as necessary. </li><li> Handle XML data formats for data interchange and interoperability between systems. </li></ul>Performance Optimization and Monitoring: <ul><li> Monitor database performance using Azure monitoring tools and implement performance tuning strategies as needed. </li><li> Identify and troubleshoot performance bottlenecks, connectivity issues, and resource contention. </li></ul>High Availability and Disaster Recovery: <ul><li> Implement high availability and disaster recovery solutions for Azure databases, such as Azure SQL Database replication, failover groups, and automated backups. </li><li> Conduct regular disaster recovery tests and ensure compliance with business continuity requirements. </li></ul>Documentation and Knowledge Sharing: <ul><li> Maintain comprehensive documentation of database configurations, migration procedures, and best practices. </li><li> Provide knowledge sharing and training to other team members on Azure database administration and migration techniques. </li></ul>REQUIRED QUALIFICATIONS <ul> <li>10 years of experience as DBA for SQL Server or Azure managed instances. </li><li>Bacheclor's degree in Computer Science or related fields. </li><li>Administering Azure SQL Database, Azure SQL Managed Instance, or other Azure database services. </li></ul> <ul><li>Strong knowledge of SQL Server administration, including database design, configuration, optimization, and troubleshooting (SQL-Server 2005, 2008 & 2012 with reporting services) </li><li>TSQL for scripting and automation of routine tasks. </li><li>Familiarity with Access, .NET, and XML for data management and interoperability </li> </ul>PREFERRED QUALIFICATIONS<ul><li>Over 10 years of experience. </li><li>Master's degree in Computer Science or relevant field. </li><li>Database management (preferably within a financial services industry) </li><li>Building and integrating multiple systems from multiple platforms </li><li>Agile Software development </li><li>Azure certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus. </li><li>Robust problem-solving capabilities and a proactive stance in recognizing opportunities for enhancement.Exceptional communication and interpersonal abilities for seamless collaboration across diverse teams.Meticulous attention to detail coupled with a steadfast dedication to precision and excellence </li><li>Flexibility in response to shifting business demands and a readiness to embrace novel technologies. </li><li>Demonstrated proficiency in a comparable role within the financial services sector. </li> </ul> Associated topics: data analytic, data architect, data manager, data management, data warehousing, database administrator, etl, mongo database, mongo database administrator, sybase

START NEW SEARCH