**Experienced Full Stack Database Administrator II – Cloud and Enterprise Data Management**
At arenaflex, we're on a mission to revolutionize the way businesses operate by leveraging cutting-edge technology and innovative solutions. As a leading player in the private sector, we're committed to delivering exceptional results and exceeding our customers' expectations. We're now seeking an experienced Full Stack Database Administrator II to join our team and play a critical role in shaping the future of our data management infrastructure.
**About arenaflex**
arenaflex is a dynamic and forward-thinking organization that's passionate about harnessing the power of technology to drive growth and success. With a strong presence in the USA, we're dedicated to providing top-notch services and solutions that meet the evolving needs of our customers. Our team is comprised of talented professionals who share a common goal: to make a meaningful impact and leave a lasting legacy.
**Job Summary**
As a Full Stack Database Administrator II at arenaflex, you'll be responsible for designing, implementing, and maintaining high-performance database systems that support our business operations. You'll work closely with cross-functional teams to ensure seamless data integration, optimize database performance, and ensure data security and integrity. If you're a seasoned database professional with a passion for innovation and a commitment to excellence, we want to hear from you!
**Key Responsibilities**
* Investigate and resolve daily database and application issues
* Collaborate with the documentation of existing systems and architectures
* Assist in the planning, execution, and support of standards and procedures for data validation, data organization, maintenance, backups, and recovery
* Support multiple databases being developed, deployed, and created in local and remote server farms
* Design and implement high-availability solutions for SQL Server, including clustering, replication, and mirroring
* Collaborate with application teams to resolve database issues and optimize database performance
* Install and configure server-based applications software in collaboration with system administrators
* Install and manage new software, updates, and fixes
* Develop and implement best practices for stored procedures, triggers, packages, tables, and views
* Optimize database performance by investigating and tuning stored procedures, creating indexes, and implementing other performance-enhancing techniques
* Design and maintain enterprise-level ETL processes using various ETL tools, including SSIS, .NET scripting, and T-SQL
* Perform database maintenance tasks and generate system reports
* Develop and implement security models
* Participate in application development cycles to ensure good database design and access procedures
* Plan, prepare, and test backup and recovery procedures for all production databases
* Monitor databases for performance and occasionally upgrade databases for optimal performance during planned downtime
* Create and manage tuning parameters as needed to improve performance
* Determine volumetric conditions to estimate new database sizes and plan accordingly for growth
* Communicate plans to system administrators
* Responsible for the security of database systems and all business/logical applications associated with it, including creating and maintaining database and application accounts, application/database fixing, and database/application security auditing
* Item checking for performance and security, participate in load test exercises
* Other duties as assigned
**Requirements**
* Strong background in client-server technology
* Working knowledge of SQL Server
* 5+ years of experience as a SQL DBA in a corporate, multi-site SQL Server environment
* Middle to advanced skills with SSIS and T-SQL
* Strong written and oral communication skills, as well as organizational and analytical skills
* Readiness and demonstrated ability to provide the highest level of customer support
* Experience with Microsoft Azure Services and moving databases into cloud environments
* Reporting Services (SSRS) and Analysis Services (SSAS) experience is preferred but not required
* Experience with .NET scripting (C# or VB.NET) as well as PowerShell is preferred but not required
* Experience in the Automotive Industry is preferred but not required
* Experience in CRM systems is preferred but not required
* Strong verbal and written communication skills; ability to communicate directly with both customers and vendors
* Strong math and analytical skills
* Ability to identify, resolve, and determine applications that have database issues
**What We Offer**
* Competitive salary range: $35-$40 per year
* Comprehensive benefits package, including medical, dental, and vision insurance
* Generous paid time off and holidays
* Opportunities for career growth and professional development
* Collaborative and dynamic work environment
* Recognition and rewards for outstanding performance
**How to Apply**
If you're a motivated and experienced database professional looking for a new challenge, we encourage you to apply for this exciting opportunity. Please submit your resume and a cover letter outlining your qualifications and experience. We can't wait to hear from you!
Apply Now!
**About arenaflex**
arenaflex is a dynamic and forward-thinking organization that's passionate about harnessing the power of technology to drive growth and success. With a strong presence in the USA, we're dedicated to providing top-notch services and solutions that meet the evolving needs of our customers. Our team is comprised of talented professionals who share a common goal: to make a meaningful impact and leave a lasting legacy.
**Job Summary**
As a Full Stack Database Administrator II at arenaflex, you'll be responsible for designing, implementing, and maintaining high-performance database systems that support our business operations. You'll work closely with cross-functional teams to ensure seamless data integration, optimize database performance, and ensure data security and integrity. If you're a seasoned database professional with a passion for innovation and a commitment to excellence, we want to hear from you!
**Key Responsibilities**
* Investigate and resolve daily database and application issues
* Collaborate with the documentation of existing systems and architectures
* Assist in the planning, execution, and support of standards and procedures for data validation, data organization, maintenance, backups, and recovery
* Support multiple databases being developed, deployed, and created in local and remote server farms
* Design and implement high-availability solutions for SQL Server, including clustering, replication, and mirroring
* Collaborate with application teams to resolve database issues and optimize database performance
* Install and configure server-based applications software in collaboration with system administrators
* Install and manage new software, updates, and fixes
* Develop and implement best practices for stored procedures, triggers, packages, tables, and views
* Optimize database performance by investigating and tuning stored procedures, creating indexes, and implementing other performance-enhancing techniques
* Design and maintain enterprise-level ETL processes using various ETL tools, including SSIS, .NET scripting, and T-SQL
* Perform database maintenance tasks and generate system reports
* Develop and implement security models
* Participate in application development cycles to ensure good database design and access procedures
* Plan, prepare, and test backup and recovery procedures for all production databases
* Monitor databases for performance and occasionally upgrade databases for optimal performance during planned downtime
* Create and manage tuning parameters as needed to improve performance
* Determine volumetric conditions to estimate new database sizes and plan accordingly for growth
* Communicate plans to system administrators
* Responsible for the security of database systems and all business/logical applications associated with it, including creating and maintaining database and application accounts, application/database fixing, and database/application security auditing
* Item checking for performance and security, participate in load test exercises
* Other duties as assigned
**Requirements**
* Strong background in client-server technology
* Working knowledge of SQL Server
* 5+ years of experience as a SQL DBA in a corporate, multi-site SQL Server environment
* Middle to advanced skills with SSIS and T-SQL
* Strong written and oral communication skills, as well as organizational and analytical skills
* Readiness and demonstrated ability to provide the highest level of customer support
* Experience with Microsoft Azure Services and moving databases into cloud environments
* Reporting Services (SSRS) and Analysis Services (SSAS) experience is preferred but not required
* Experience with .NET scripting (C# or VB.NET) as well as PowerShell is preferred but not required
* Experience in the Automotive Industry is preferred but not required
* Experience in CRM systems is preferred but not required
* Strong verbal and written communication skills; ability to communicate directly with both customers and vendors
* Strong math and analytical skills
* Ability to identify, resolve, and determine applications that have database issues
**What We Offer**
* Competitive salary range: $35-$40 per year
* Comprehensive benefits package, including medical, dental, and vision insurance
* Generous paid time off and holidays
* Opportunities for career growth and professional development
* Collaborative and dynamic work environment
* Recognition and rewards for outstanding performance
**How to Apply**
If you're a motivated and experienced database professional looking for a new challenge, we encourage you to apply for this exciting opportunity. Please submit your resume and a cover letter outlining your qualifications and experience. We can't wait to hear from you!
Apply Now!