Mid-level Database Administrator en Institute for Building Technology and Safety
Institute for Building Technology and Safety · Ashburn, Estados Unidos De América · Onsite
- Professional
- Oficina en Ashburn
The Mid-level Database Administrator is responsible for the stability, security, monitoring and performance of the database platform. Serves as lead and technical point of contact for customers and associated members of the Engineering and Development team.
- Install, configure, and upgrade database software (SQL Server, MySQL, MongoDB, etc.)
- Conduct hands on engineering activities across Microsoft database technologies and multiple system administration technologies.
- Manage database backup jobs, capacity, planning, and storage growth.
- Implement data archiving, retention and purging policies.
- Provide and/or support the development of technical documentation related to any support, training and transitioning.
- Participate in disaster recovery planning/testing.
- Tune queries, indexes and stored procedures for better performance.
- Demonstrate technical knowledge and consultative skills, while working effectively with customers and Engineering/Development team members.
- Support engineering and development team in patches, updates & troubleshooting as needed.
- Implement data archiving, retention and purging policies.
- Bachelor’s degree in Software Development or 60 months (about 5 years) hands-on experience.
- 5+ years of work experience in Database Development, Administration & Support in MS SQL Server environment.
- Certifications: Experience with SQL and Virtual DB environments.
Key Skills/Competencies for this position
- Experience in installing & configuring database software (SQL Server, MySQL, MongoDB, etc.)
- Strong understanding of SQL Server setup, configuration, patching and maintenance.
- Skilled in installing & configuring SQL Server Reporting Services (SSRS) and developing custom reports.
- Experienced designing & managing database schemas, implementing role-based access controls.
- Comprehensive experience in database administration, development & monitoring backup jobs.
- Hands-on experience with cloud-based database deployment and configuration, specifically Azure SQL Database.
- Experience in cloud and on-premises performance tuning, cost optimization, automation, and implementing security best practices.
- Experience in cloud and on-premises SQL Monitoring, database backups health, query tuning & indexing strategies for better performance.
- Experience configuring high availability and disaster recovery solutions, including Geo-replication and failover clustering.
- Skilled in migrating databases from on-premises SQL server to Azure SQL or Managed Instances.
- Knowledgeable in database backup and recovery using SSMS or third-party tools (e.g., DRUVA).
- Proficient in writing complex SQL queries, including stored procedures, functions, views, etc.
- Ability to troubleshoot database issues using built-in and third-party diagnostic tools.
- Experience developing and deploying packages with SQL Server Integration Services (SSIS).
- Familiar with tape-based backup solutions and strategies.
- Experience configuring and managing recovery strategies (full, differential, incremental, log backups).
- Skilled in conducting root cause analysis and resolving database related issues.
- Understanding of technology governance - security & access policies, audits & compliance.
- Knowledgeable in security principles and best practices within database environments.
- Collaborate with Engineering teams to support server maintenance and upgrades.
- Able to assist with diagnosing and resolving network-related issues in collaboration with Engineering team.
Desired Skills:
- Data Modelling & Data Standards.
- Familiarity with Windows Clustering and HA concepts.
- Datawarehouse design and modelling.
- Experience with LightSpeed and Spotlight is a plus
- Experience with Redgate tools (SQL Structure & Data Compare)
- Experience Postgres/MongoDB is a plus
Personal Qualities
IBTS places a high value on certain personal traits that work toward creating a positive, professional, and supportive work environment, which is essential for working together and achieving success. We believe “how” you achieve your results is as important as what you achieve. The following highlights the personal traits key for success within the organization.
- Strong Work Ethic
- Teachable/Continuous Learner
- Reliable/Dependable
- Collaborative/Team Contributor
- Must be able to travel, if necessary, up to 50% time
- Must be able to lift and/or move up to 25 lbs.
Must be able to sit for extended periods of time depending on workload and/or emergencies.
Company Overview:Bring your passion, expertise, and experience to IBTS, where we appreciate and are committed to our employees. We offer outstanding benefits, growth opportunities, and work hard to maintain a culture that values our employees.
The Institute for Building Technology and Safety (IBTS) is a 501(c) (3) non-profit organization established to provide unbiased professional building code compliance services, while enhancing the communities in which we work. At IBTS, our mission is to deliver quality services to meet the challenges of governance at all levels while enhancing public safety, economic development, and the general welfare of the community. Our services include Building and Community Development, Energy and Sustainability Services, Disaster Planning and Recovery, Quality Assurance, as well as Compliance and Risk Monitoring.
IBTS is headquartered in Ashburn, VA, with additional offices in Louisiana, Missouri, New York, Puerto Rico, and Washington, DC.
We are committed to building a community of experts with diverse backgrounds, disciplines, and perspectives who are passionate about our mission. IBTS is proud to be an Equal Opportunity and Affirmative Action Employer that maintains a diverse and inclusive workforce. All qualified applicants will receive equal consideration for employment without regard to race, color, religion, sex, national origin, age, disability or sexual orientation. This opportunity is open to Section S3 Residents. Veterans and individuals with disabilities are encouraged to apply.
Explore the opportunities!
Solicitar ahora