Senior SQL Database Developer

1 month ago

Rosslyn, United States Financial Services company Full time
Job DescriptionJob Description

We work on a HYBRID onsite schedule of 5 days onsite per month

We are not sponsoring Visa's at this time

You must live in the Washington, DC metro area.

 

You will be a key member of our Application Development Team, solving complex and unique business challenges with forward-looking architectures in a collaborative Agile environment. You will be working on a team of engineers with a broad range of skills to develop new products, modernize existing systems, and support our customers using new and traditional technologies, such as MS SQL, SQL Server, AWS/cloud, and related technologies.

Responsibilities

  • Lead the SQL installation, configuration, design, and testing of production-focused databases, supporting all data-related activities. Identify user requirements, set up database structures, test, and coordinate modifications to these systems.
  • Lead migration of reports from SSRS to PowerBI or similar SAAS platform.
  • Create and maintain data loads from external clients via Talend (ETL) and manipulate data via a strong knowledge of ETL and SQL stored procedures.
  • Perform complex "ad hoc" queries, data assembly, and reporting functions for delivery to internal and external teams.
  • Implement database performance monitoring, mapping of conceptual designs, refining logical designs, data modeling, maintaining data standards and protection (encryption), writing database documentation (standards, procedures, definitions), defining access control and permissions, managing backup and recovery paths, and participating in capacity planning.
  • Provide ongoing maintenance of all organizational production and administrative data sources to ensure data integrity and database security. Troubleshoot database errors, indexing, speed, or other concerns. Coordinate with the Technology and Lead Developer to ensure all data storage and retrieval capabilities are properly supported and maintained within our IT infrastructure.
  • Produce and maintain database documentation (e.g., data dictionary, Entity Relationship Diagrams) as required for proper system maintenance and system enhancements.
  • Lead the discovery, mock-up, creation, testing, scheduling, and ongoing revision of SQL/SSRS-based business reports.
  • Maintain multiple SQL server instances including SQL and OS versions, compatibility, and upgrades, working with external vendors to ensure functionality, etc.
  • Coordinate closely with team members, product owners, and scrum masters to ensure user-story alignment and development per business requirements.
  • Continue to develop personal field of knowledge in database and related technologies by attending conferences, prototyping new technologies, and exploring new areas of interest.
  • Work across departments to design and deliver solutions from inception to production.
  • Build subject-matter expertise of our core back-end financial processes.
  • Provide support and troubleshooting capabilities to our production systems, as needed, to remediate unexpected issues and outages.
  • Develop and evangelize best practices in line with current trends and technologies, with consideration for our existing policies and procedures.
  • Leverage Atlassian tool suite, including JIRA and Confluence, to track activities and progress.
  • Champion new technology and innovation, while keeping existing systems up-to-date and secure.

Requisite Experience, Skills, and Qualifications

  • Bachelor’s degree in computer science or relevant field.
  • 5 plus years of experience, strong proficiency, and hands-on expertise in MS/SQL, including stored procedures, views, and functions.
  • 3 plus years of experience, strong proficiency, and hands-on expertise with AWS, and related technologies.
  • Experience with software development lifecycle (SDLC) from conception through end of life.
  • Knowledge of value code quality and best practices.
  • Experience with version control system (e.g., Git).
  • Experience with an issue/problem-tracking system (e.g., Jira).
  • High motivation to deliver a quality product on time, every time.
  • Ability to work in a fast-paced environment and handle rapidly changing work requirements and priorities.
  • Ability to consistently use team project and collaboration software tools including Jira, MS Teams, etc.
  • Strong organizational skills.
  • Ability to work independently against project milestones to achieve objectives with minimal supervision.
  • Excellent problem-solving skills and the ability to multitask within tight deadlines.
  • Drive to investigate new technologies and the ability to articulate concepts and designs.
  • Excellent written, verbal, and visual communication skills to explain complex topics concisely to both technical and nontechnical audiences.
  • Excellent mathematical skills.
  • Comprehensive knowledge of database administration and development.
  • Comprehensive knowledge of data analysis, modeling, and database design techniques.
  • Skill in performing complex and specialized database functions.
  • Comprehensive knowledge of structured query language (SQL), SSRS, ETL, and report-writing.
  • Strong experience with reporting tools (SQL, SSRS, BI, etc.).
  • Comfort with both on-prem and cloud-based SQL deployments.
  • Comprehensive knowledge in stored procedures; SQL scripts, database security, backups, and recovery.
  • Comprehensive experience using SQL Server Management Studio and related SQL tools (RedGate, etc.).
  • Skill in evaluating changes in the production environment and anticipating resources needed to meet those changes.
  • Experience with high availability, fault tolerance, and disaster recovery.

Preferred Qualifications

  • Experience in financial applications.
  • Knowledge of accounting.
  • Certifications in Java.
  • Knowledge of CI/CD tools, such as Jenkins, SonarQube, and Junit.
  • Knowledge of Agile Development tools, such as Jira, Bitbucket, and Confluence.
  • Experience with Cloud formation (yaml) and similar languages.
Company DescriptionPublicly held global Investment firmCompany DescriptionPublicly held global Investment firm

  • Technical Business Analyst

    2 weeks ago

    Rosslyn, United States National FinTech Engineering Full time

    Job DescriptionJob DescriptionWe work a HYBRID onsite system of 5 days per month (once a week)We are not able to sponsor visa's at this time.Technical Business Analyst -- Must know SQL and have some exposure to Cloud (AWS) What is the role?You would be a key member of our Product Delivery Team, leading the team’s development efforts to support our...

  • Technical Business Analyst

    1 month ago

    Rosslyn, United States National FinTech Engineering Full time

    Job DescriptionJob DescriptionWe work a HYBRID onsite system of 5 days per month (once a week)We are not able to sponsor visa's at this time.Technical Business Analyst -- Must know SQL and have some exposure to Cloud (AWS) What is the role?You would be a key member of our Product Delivery Team, leading the team’s development efforts to support our...

  • Technical Business Analyst

    11 hours ago

    Rosslyn, United States National FinTech Engineering Full time

    Job DescriptionJob DescriptionWe work a HYBRID onsite system of 5 days per month (once a week)We are not able to sponsor visa's at this time.Technical Business Analyst -- Must know SQL and have some exposure to Cloud (AWS) What is the role?You would be a key member of our Product Delivery Team, leading the team’s development efforts to support our...

  • Crystal Reports Developer/Analyst

    6 days ago

    Rosslyn, United States Experis Full time

    Position: Crystal Reports Developer/Analyst Location: Washington, DC (metro accessible) Duration: Long Term Contract Hybrid: Onsite Tuesdays, Wednesdays, Thursdays The team is seeking a Techno Functional Analyst with Asset Management/Portfolio Performance and Risk background to help analyze initiatives that involve report analysis and data cataloguing. The...

  • Java Technical Architect

    3 weeks ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionTechnical Architect - JAVA and AWS We are onsite 5 days per month.Visa Sponsorships are not available at this time. You will be a key member of our Accounting Software Application Development Team, solving complex and unique business challenges with forward-looking architectures in a collaborative Agile environment. As an...

  • Java Technical Architect

    5 days ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionTechnical Architect - JAVA and AWS We are onsite 5 days per month.Visa Sponsorships are not available at this time. You will be a key member of our Accounting Software Application Development Team, solving complex and unique business challenges with forward-looking architectures in a collaborative Agile environment. As an...

  • Technical Architect

    1 month ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionTechnical Architect - JAVA We are onsite 5 days per month.Visa Sponsorships are not available at this time. You will be a key member of our Accounting Software Application Development Team, solving complex and unique business challenges with forward-looking architectures in a collaborative Agile environment. As an architect...

  • Technical Architect

    16 hours ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionTechnical Architect - JAVA We are onsite 5 days per month.Visa Sponsorships are not available at this time. You will be a key member of our Accounting Software Application Development Team, solving complex and unique business challenges with forward-looking architectures in a collaborative Agile environment. As an architect...

  • Senior Test Manager

    7 days ago

    Rosslyn, United States Sekon Full time

    Job DescriptionJob DescriptionSalary: SeKON is looking for a Senior Test Manager to join our talented and innovative team supporting the Defense Health Agency (DHA) and its program offices. We are looking for a Senior Test Manager to help with overseeing and supporting the testing & evaluation (T&E) platform, including both program management and execution....

  • Senior Test Manager

    1 day ago

    Rosslyn, United States Sekon Full time

    Job DescriptionJob DescriptionSalary: SeKON is looking for a Senior Test Manager to join our talented and innovative team supporting the Defense Health Agency (DHA) and its program offices. We are looking for a Senior Test Manager to help with overseeing and supporting the testing & evaluation (T&E) platform, including both program management and execution....

  • Senior Cyber Analyst

    2 months ago

    Rosslyn, United States Peraton Full time

    About Peraton Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our...

  • Vp of Business Development

    7 days ago

    Rosslyn, United States Logically Full time

    **Rosslyn, VA** **Logically USA /** **Permanent /** **Hybrid** **About Logically** Founded in 2017, Logically combines artificial intelligence with expert analysts to tackle harmful and manipulative content at speed and scale. We work to reduce the individual, institutional, and societal damage caused by misleading and deceptive online discourse. In...

  • Junior Identity Intelligence Specialist

    7 days ago

    Rosslyn, United States All Native Group Full time

    Summary: The **Junior Identity Intelligence Specialist **shall provide analysis, research, assistance, training, and support for the vetting of local national employees and job applicants, as well as other individuals as needed, for Regional Security Offices at U.S. Embassies and Consulates worldwide. - Utilizes numerous databases, specialized tools, and...

  • Senior Executive Assistant

    1 month ago

    Rosslyn, United States Optima Global Solutions Full time

    Optima Global Solutions Inc.is a valuable IT Services and Solution provider that customers, employees, and stakeholders feel proud to be associated with. Optima's Intelligent Automation Solutions leverage robotic process automation, intelligent data capture, and business process management best practices to streamline operations. Our IT Services practice...

  • Identity Intelligence Analyst

    7 days ago

    Rosslyn, United States All Native Group Full time

    Summary: The Identity Intelligence Analyst (Entry Level) shall assist with analysis, research, training, and support for the vetting of local national employees and job applicants, as well as other individuals as needed, for Regional Security Offices at U.S. Embassies and Consulates worldwide. - Assist with conducting analysis of biometric and biographic...

  • Software Business Analyst

    2 weeks ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionBUSINESS ANALYST -- Software -- SQLthis is a Hybrid onsite position; we require you to be onsite 5 days per month.We cannot sponsor visas at this time You will be a key member of our Product Delivery Team, leading the team’s development efforts to support our existing customer-facing applications and develop new solutions to...

  • Software Business Analyst

    2 weeks ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionBUSINESS ANALYST -- Software -- SQLthis is a Hybrid onsite position; we require you to be onsite 5 days per month.We cannot sponsor visas at this time You will be a key member of our Product Delivery Team, leading the team’s development efforts to support our existing customer-facing applications and develop new solutions to...

  • Sr Functional Analyst

    4 days ago

    Rosslyn, Virginia, United States tapwage Full time

    Position SummaryIn this age of disruption, organizations need to navigate the future with confidence by tapping into the power of data analytics, robotics, and cognitive technologies such as Artificial Intelligence (AI). Our Strategy & Analytics portfolio helps clients leverage rigorous analytical capabilities and a pragmatic mindset to solve the most...

  • Sr Functional Analyst

    2 days ago

    Rosslyn, Virginia, United States tapwage Full time

    Position SummaryIn this age of disruption, organizations need to navigate the future with confidence by tapping into the power of data analytics, robotics, and cognitive technologies such as Artificial Intelligence (AI). Our Strategy & Analytics portfolio helps clients leverage rigorous analytical capabilities and a pragmatic mindset to solve the most...

  • Engineer, Software Development

    2 days ago

    Rosslyn, VA, United States Comcast Corporation Full time

    Make your mark at Comcast a Fortune 30 global media and technology company. From the connectivity and platforms we provide, to the content and experiences we create, we reach hundreds of millions of customers, viewers, and guests worldwide. Become part of our award-winning technology team that turns big ideas into cutting-edge products, platforms, and...