Senior SQL Database Developer

3 months 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

  • Senior Java Solutions Architect

    2 weeks ago

    Rosslyn, Virginia, United States Financial Services company Full time

    Job OverviewPosition: Senior Java Solutions ArchitectWork Arrangement: Onsite presence required 5 days per month.Visa Sponsorship: Currently not available.POSITION SUMMARY: We are seeking an experienced professional capable of swiftly adapting to a diverse technological landscape, with expertise in AWS, Java, and related technologies. A solid understanding...

  • Software Business Analyst

    2 months ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionBUSINESS ANALYST this 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 meet the diverse...

  • Technical Business Analyst

    4 months 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...

  • Senior Director, Membership

    3 weeks ago

    Rosslyn, United States American Chiropractic Association Full time

    The Senior Director of Membership oversees the development, implementation, and evaluation of membership growth strategies, as well as the day-to-day management of the membership department. This individual is responsible for recruitment and retention, budgeting and customer service for an association of 10,000 individual members and reports to the Executive...

  • Senior Manager, Educational Activities

    2 months ago

    Rosslyn, United States American Pharmacists Association Full time

    Senior Manager, Educational ActivitiesWashington, D.C.The American Pharmacists Association is the largest association representing pharmacists in all practice settings in the United States and is the only organization advancing the entire pharmacy profession.Our expert staff, and strong volunteer leadership, including many experienced pharmacists, allow us...

  • Senior Manager, Membership

    3 hours ago

    Rosslyn, United States American Pharmacists Association Full time

    Senior Manager, Membership & Chapter OperationsWashington, D.C.The American Pharmacists Association is the largest association representing pharmacists in all practice settings in the United States and is the only organization advancing the entire pharmacy profession.Our expert staff, and strong volunteer leadership, including many experienced pharmacists,...

  • Consulting, Senior Manager

    3 months ago

    Rosslyn, VA, United States Deloitte Full time

    Position Summary Deloitte Consulting LLP seeks a Consulting, Senior Manager in Rosslyn, Virginia and various unanticipated Deloitte office locations and client sites nationally. Work You’ll DoOversee information technology projects and the software advisory and implementation of services to help companies unlock the value of technology investments...

  • Federal Health Consultant

    3 months ago

    Rosslyn, VA, United States Deloitte Full time

    Position Summary Bioinformatics Data Scientist In 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...

  • Senior Manager, Digital Marketing

    1 month ago

    Rosslyn, United States American Pharmacists Association Full time

    Senior Manager, Digital MarketingWashington, D.C.The American Pharmacists Association is the largest association representing pharmacists in all practice settings in the United States and is the only organization advancing the entire pharmacy profession.Our expert staff, and strong volunteer leadership, including many experienced pharmacists, allow us to...

  • Manager, Member Engagement

    1 day ago

    Rosslyn, United States National Automatic Merchandising Association Full time

    Summary of Position:NAMA is seeking a highly motivated Manager, Member Engagement with a can-do attitude to provide exceptional customer service to current and prospective members, effectively communicate NAMA’s value proposition, and identify areas to improve member experience.The Manager, Member Engagement will work collaboratively across teams and...

  • Senior Cyber Threat Engineer

    1 month ago

    Rosslyn, Virginia, United States Shift5 Full time

    Our Values :Embrace Truth and Integrity: Base decisions on data, foster open dialogue, and uphold unwavering integrity.User-Centric Focus: Prioritize user needs to guide our actions and resource allocation.Collaborative & Adaptable: Collaborate for excellence, learning from failures and driving iterative improvements, recognizing every decision's...

  • Java Software Engineer

    4 months ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionThis is a HYBRID role. Requires 5 days per month ONSITE in Arlington, VAWe are unable to sponsor Visa's at this time Software Engineer (Customer-Facing Applications)Your RoleYou would be a key member of our Customer-Facing Application Development Team, solving complex and unique business challenges with forward-looking...

  • C++ Developer

    1 month ago

    Rosslyn, VA, United States Deloitte Full time

    Position Summary Are you looking to make an immediate impact where you can help our clients solve their business challenges?  Deloitte’s Core Business Operations (CBO) portfolio operates at the center of our client’s business. By joining our team, you could help C-suite and program leaders transform their organization and accelerate mission...

  • Cloud Infrastructure Automation Engineer

    2 weeks ago

    Rosslyn, Virginia, United States Financial Services company Full time

    Job Title: Cloud Infrastructure Automation EngineerLocation: RemoteEmployment Type: Full TimeYour RoleThe position of a Cloud Infrastructure Automation Engineer is crucial within our Automation Services division, concentrating on large-scale automation initiatives, establishing best practices, guiding strategic directions, delivering reusable shared...

  • Senior Manager, Workday Implementation

    1 month ago

    Rosslyn, VA, United States Deloitte Full time

    Position Summary Deloitte’s Enterprise Performance professionals are leaders in optimizing operations that span the entire enterprise of an organization, from strategy to implementation and operation. By joining our team, you can help clients achieve impact and value from their investments in both people and technology that support enterprise-wide...

  • AWS DevOps Platform Engineer

    3 months ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionThis is a HYBRID onsite position. We require you to be onsite 5 days per MONTH.We are unable to sponsor visa at this timeDevOps Platform EngineerFull TimeArlington, VA, USYour RoleThe DevOps Platform Engineer is a crucial member of our Automation Services team, which focuses on enterprise-level automation activities, including...

  • AWS DevOps Platform Engineer

    3 months ago

    Rosslyn, United States Financial Services company Full time

    Job DescriptionJob DescriptionThis is a HYBRID onsite position.  We require you to be onsite 5 days per MONTH.We are unable to sponsor visa at this timeDevOps Platform EngineerFull TimeArlington, VA, USYour RoleThe DevOps Platform Engineer is a crucial member of our Automation Services team, which focuses on enterprise-level automation activities, including...

  • Data Analytics Developer

    1 month ago

    Rosslyn, VA, United States Deloitte Full time

    Position Summary In 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...

  • Advisory Manager

    4 weeks ago

    Rosslyn, VA, United States Deloitte Full time

    Position Summary Are you ready for an exciting opportunity that offers professional growth? Do you want to utilize cutting edge approaches and technology to identify and mitigate emerging threats within our client environments, all while helping support important missions? Are you a problem solver and an innovator with a passion for investigating...

  • Senior Refugee Operations Manager

    2 weeks ago

    Rosslyn, Virginia, United States Credence Management Solutions, LLC Full time

    Refugee Processing Business ManagerJob Summary:The Refugee Processing Business Manager is a key leadership role at Credence Management Solutions, LLC, responsible for overseeing all refugee operational activities within the Refugee Processing Center (RPC). This position plays a pivotal role in managing and supervising the support and implementation of...