- Senior
Responsible for the analysis, performance, and administration of database technologies across enterprise environments, including real estate applications. Guides the design and implementation of new or improved data processing systems, ensuring optimal performance, security, and scalability.
Job Duties and Responsibilities (Essential Job Functions) Common job activities are listed below; actual position responsibilities may vary. Refer to your manager or human resources for specific duties and performance expectations.
1. Database Performance & Optimization
- Serve as the performance tuning expert across enterprise SQL Server environments.
- Analyze and optimize SQL queries, indexes, and database configurations to improve application responsiveness.
- Troubleshoot performance issues including blocking, deadlocks, and wait times.
- Provide guidance and hands-on support to development teams for performance tuning and query re-writes.
- Monitor and analyze database performance and proactively make recommendations and adjustments.
2. Safety & Reliability
- Set and enforce security standards and safeguard data assets.
- Ensure confidentiality, integrity, and availability of company data through appropriate cybersecurity and data management mechanisms.
- Support production environments, ensuring availability, scalability, and reliability of mission-critical databases.
- Participate in production support and off-hour maintenance and migration activities.
3. Collaboration & Support
- Collaborate with business, infrastructure, application development, and data team resources.
- Interface with managers and staff to develop administrative and programming solutions to projects.
- Provide tooling, guidance, and consultation to engineering teams while mentoring junior engineers to meet company standards and grow their technical expertise.
4. Automation & Documentation
- Automate administrative tasks through scripting languages (Python, PowerShell, etc.) or third-party tools.
- Develop and maintain documentation, best practices, and training materials to upskill other DBAs and developers.
5. Cloud & Systems Management
- Facilitate the transition to cloud native database technologies from legacy and on-premises implementations.
- Contribute to capacity planning, system upgrades, and future-proofing of database environments.
- Configure and maintain replication, availability groups, and log shipping.
6. Reporting & Analysis
- Utilize reporting tools to create custom reports from company systems.
- Analyze sales and marketing data through a variety of databases and related system reports to provide management quantitative data for evaluation and metrics reporting.
- Research, analyze and troubleshoot data integrity issues.
7. Project Management
- Perform project management activities including definition, planning, analysis, specification, documentation, and testing.
- Work with developers to coordinate and support the integration of development projects.
8. Support data-driven applications for input and management of data to support back-office functions.
9. Perform other duties as requested or as needed to fulfill the purpose of the job
Performance Expectations
- Meet all performance and behavior expectations outlined in the company performance appraisal form or communicated by management.
- Perform responsibilities as directed achieving desired results within expected time frames and with a high degree of quality and professionalism.
- Establish and maintain positive and productive work relationships with all staff, customers and business partners.
- Demonstrate the behavioral and technical competencies necessary to effectively complete job responsibilities. Take personal initiative for technical and professional development.
- Follow the company HR Policy, the Code of Business Conduct and all subsidiary and department policies and procedures, including protecting confidential company information, attending work punctually and regularly, and following good safety practices in all activities.
Qualifications
Education:
- Bachelor’s Degree in information systems, computer science, business management or related field; or equivalent work experience and knowledge.
Experience:
- 10+ years of experience with database technology, including MSSQL, Postgres, and Oracle.
- 5+ years of professional experience with cloud native database technologies (AWS, GCP, Azure).
- Prior experience with Microsoft SQL, MySQL, Oracle, and Microsoft PowerBI.
Knowledge and Skills:
- Strong computer skills, including advanced knowledge of Crystal Reports, Excel and Access.
- Effective oral and written communication skills.
- Ability to prioritize and organize multiple tasks and projects concurrently.
- Effective analytical and problem solving skills.
- Knowledge of the real estate programs and industry preferred.
Wage: $128,000 - $149,000 annually; actual wage is based upon education and experience.
Benefits: Full suite of benefits including Medical, Health Savings Account, Dental, Vision, Life Insurance, Paid Vacation (PTO), 401(k) with employer match, Flexible Spending Account, and Employee Assistance Program (EAP)
Location: This position is open to remote work hiring within the U.S. mainland.
Equal Opportunity Employer
Jetzt bewerben