Experienced Full Stack Database Administrator – Cloud and Enterprise Data Management
At arenaflex, we're on a mission to revolutionize the way businesses operate in the digital age. As a leading innovator in the private sector, we're constantly pushing the boundaries of what's possible with technology. Our team of experts is dedicated to delivering cutting-edge solutions that drive growth, efficiency, and customer satisfaction. We're now seeking an experienced Full Stack Database Administrator to join our dynamic team. As a key member of our database management team, you'll play a critical role in ensuring the smooth operation of our enterprise data systems. If you're passionate about database administration, cloud computing, and enterprise data management, we want to hear from you!
Job Summary:
As a Full Stack Database Administrator 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 identify and resolve database-related issues, develop and implement database standards and best practices, and ensure the security and integrity of our data assets.
Key Responsibilities:
* Investigate and resolve daily database and application issues, ensuring minimal downtime and maximum system availability
- Collaborate with the documentation team to develop and maintain accurate documentation of existing systems and processes
- Participate in the planning, execution, and support of standards and methodologies for data validation, data governance, backup and recovery, and data security
- Support the development, testing, and deployment of multiple databases across 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-related issues and ensure optimal database performance
- Install and configure server-based applications in collaboration with system administrators
- Install and manage new software, updates, and fixes, ensuring minimal disruption to business operations
- 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 modifying database configurations
- Design and maintain enterprise-level ETL processes using various ETL tools, including SSIS, .NET programming, and T-SQL
- Perform database maintenance tasks and generate system reports as required
- Develop and implement security models to ensure data confidentiality, integrity, and availability
- Participate in application development cycles to ensure optimal database design and access procedures
- Plan, prepare, and test backup and recovery procedures for all production databases
- Monitor databases for performance and periodically upgrade databases for optimal performance during scheduled maintenance windows
- Create and manage tuning parameters to improve performance
- Assess volumetric conditions to estimate new database sizes and plan accordingly for growth
- Communicate plans to system administrators
- Ensure 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
- Perform item checking for performance and security, participate in load test exercises
- Perform 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 business, multi-site SQL Server environment
- Middle to advanced skills with SSIS and T-SQL
- Excellent written and verbal communication skills, as well as organizational and interpersonal skills
- Ability and willingness to provide the highest level of customer support
- Experience with Microsoft Azure Services and migrating databases to cloud environments
- Reporting Services (SSRS) and Analysis Services (SSAS) experience is preferred but not required
- Experience with .NET programming (C# or VB.NET) and 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 work with databases
What We Offer:
* Competitive salary and benefits package
- Opportunities for career growth and professional development
- Collaborative and dynamic work environment
- Flexible work arrangements, including remote work options
- Access to cutting-edge technology and tools
- Recognition and rewards for outstanding performance
- Comprehensive training and support
How to Apply:
If you're a motivated and experienced database administrator looking for a new challenge, we encourage you to apply for this exciting opportunity. Please submit your resume and cover letter to [arenaflex careers page](https://arenaflex.com/careers). We can't wait to hear from you! Apply for this job