The Role
Designs, develops, and maintains SQL Server databases, complex queries, stored procedures, data models, ETL processes, security controls, and performance optimization solutions. Manages backup, recovery, high availability, disaster recovery, and data quality across environments. Collaborates with application developers, analysts, and business teams to support reporting and visualization, while documenting database architecture and best practices.
Summary Generated by Built In
Responsibilities:
- Design, develop, and maintain SQL Server databases, ensuring efficient data storage and retrieval.
- Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and triggers for performance improvements.
- Work closely with application developers to ensure seamless integration of database components with applications.
- Perform database tuning and optimization (PTO), including indexing strategies, query execution plans, and partitioning.
- Develop and maintain ETL (Extract, Transform, Load) processes to facilitate data movement and transformation between systems.
- Implement database security best practices, including user authentication, role-based access control, and encryption.
- Monitor and analyze database performance, addressing bottlenecks and optimizing resource utilization.
- Design and implement backup and recovery strategies to ensure data integrity and business continuity.
- Collaborate with data analysts and Product/business teams to support reporting and data visualization needs using SQL-based reporting tools.
- Maintain documentation of database structures, procedures, and best practices to ensure knowledge sharing and compliance.
- Ensure data quality and consistency across multiple environments, including Development, Staging, and Production.
- Develop and maintain data models, including logical and physical data design.
- Stay updated with the latest SQL Server features, best practices, and industry trends.
- Implement High Availability (HA) and Disaster Recovery (DR) options such as failover clustering, database mirroring, log shipping, and replication.
- Manage user security, including logins, roles, and privileges to ensure data integrity and security compliance.
- Optional: Experience with Business Intelligence (BI) tools such as SSIS, SSRS, and SSAS for advanced analytics and reporting.
- Optional: Experience working in financial markets or similar data-intensive domains is an added advantage.
Required Skills & Qualifications:
- Strong expertise in SQL Server development, including T-SQL, query optimization, and stored procedures.
- Experience in database design, normalization, and data modeling.
- Knowledge of performance tuning techniques, indexing, and execution plan analysis.
- Familiarity with ETL tools and data warehousing concepts.
- Proficiency in working with version control tools such as Git.
- Excellent problem-solving skills and ability to troubleshoot database-related issues.
- Strong communication skills and ability to collaborate with cross-functional teams.
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Skills Required
- Strong expertise in SQL Server development, including T-SQL, query optimization, and stored procedures
- Experience with database design, normalization, and data modeling
- Knowledge of performance tuning, indexing, and execution plan analysis
- Familiarity with ETL tools and data warehousing concepts
- Proficiency with version control tools such as Git
- Excellent problem-solving and database troubleshooting skills
- Strong communication and cross-functional collaboration skills
- Bachelor's degree in Computer Science, Information Technology, or a related field
- Experience with BI tools such as SSIS, SSRS, and SSAS
- Experience working in financial markets or similar data-intensive domains
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
FactEntry is a London-headquartered provider of fixed-income reference data, bond pricing, analytics, and related data solutions for debt-capital-markets professionals. Its products include a validated securities master and reference database, bond valuation engine, corporate-actions tracking, bond-document database, municipal disclosures, and regulatory data services. The company combines analyst-led research with machine learning and natural-language-processing technologies to deliver reliable market data and monitoring.
