Senior SQL Database Developer

3 weeks ago


Richmond, United States Financial Inc Full time

Job Description

Job 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 Description Publicly held global Investment firm

Company Description

Publicly held global Investment firm #J-18808-Ljbffr



  • Richmond, United States DataStaff Full time

    DataStaff is in need of a Senior Oracle Database Developer for one of our direct clients in the Richmond, VA area for a long-term contract opportunity.*This position is hybrid; the selected candidate must work onsite 1-2 days per week.Required Experience:Experienced PL/SQL developer with skills in Oracle codingMust also have ability to do data analysis,...


  • Richmond, United States Trillium Staffing Full time

    Trillium Professional is now looking for two Senior PL/SQL Oracle Database Developers in Downtown Richmond. Must be willing and able to work onsite two days a week for the first couple of weeks, and then one to two days a week thereafter. Assignment expected to last 12-24 months. Pay is $55 per hour. Apply now! Requirements *Experienced PL/SQL developer...

  • PL/SQL Developer

    1 week ago


    Richmond, United States Crescens Full time

    Title: PL/SQL Developer Location: Richmond VA Duration: 6+ Months Type: ContractNote: Local Richmond, VA candidates only Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA Contractor will be responsible for purchasing parking through VDOT's Parking Management Office or procuring their own parking Job Description:...


  • Richmond, United States Swift Strategic Solutions Inc Full time

    A Public Sector client of ours is looking for a Senior Oracle Database Developer to work on their ongoing project in the Richmond, VA office.Below are the additional details of this role: Required Skills:We need a minimum of 10+ years of hands-on experience in the following.Experience working with Oracle PL/SQL and SQL Server Database Development.Written and...


  • Richmond, United States Equinox Consulting Partners LLC Full time

    Equinox Consulting Partners LLC is seeking an experienced Senior PL/SQL Developer with strong Oracle coding skills to join our team in Richmond, VA. The ideal candidate will have expertise in PL/SQL development, data analysis, requirements development, and data modeling. Additionally, experience in application backend support, building interfaces between...


  • Richmond, United States Equinox Consulting Partners LLC Full time

    Equinox Consulting Partners LLC is seeking an experienced Senior PL/SQL Developer with strong Oracle coding skills to join our team in Richmond, VA. The ideal candidate will have expertise in PL/SQL development, data analysis, requirements development, and data modeling. Additionally, experience in application backend support, building interfaces between...


  • Richmond, United States OP Consulting Group LLC Full time

    Position : Senior Oracle Database DeveloperLocation : Richmond,VADuration : 24+ Months Job Description Experienced PL/SQL developer with skills in Oracle coding Must also have ability to do data analysis, develop requirements and data models. Must have background in application backend support, Oracle PL/SQL and MS SQL server development. Must have...


  • Richmond, United States HS Solutions Full time

    Job Description:Looking for two Sr. PL/SQL Oracle Database Developers in Downtown Richmond. Must be willing and able to work onsite two days a week for the first couple of weeks, and then one to two days a week thereafter. Assignment expected to last 12-24 months.Requirements*Experienced PL/SQL developer with skills in Oracle coding*Must also have ability to...


  • Richmond, United States HS Solutions Inc Full time

    Job Description:Looking for two Sr. PL/SQL Oracle Database Developers in Downtown Richmond. Must be willing and able to work onsite two days a week for the first couple of weeks, and then one to two days a week thereafter. Assignment expected to last 12-24 months.Requirements*Experienced PL/SQL developer with skills in Oracle coding*Must also have ability to...


  • Richmond, United States HS Solutions Inc Full time

    Job Description:Looking for two Sr. PL/SQL Oracle Database Developers in Downtown Richmond. Must be willing and able to work onsite two days a week for the first couple of weeks, and then one to two days a week thereafter. Assignment expected to last 12-24 months.Requirements*Experienced PL/SQL developer with skills in Oracle coding*Must also have ability to...


  • Richmond, United States HS Solutions Inc Full time

    Job Description:Looking for two Sr. PL/SQL Oracle Database Developers in Downtown Richmond. Must be willing and able to work onsite two days a week for the first couple of weeks, and then one to two days a week thereafter. Assignment expected to last 12-24 months.Requirements*Experienced PL/SQL developer with skills in Oracle coding*Must also have ability to...


  • Richmond, United States CyberTec Full time

    Job Title: Senior SQL Server AdministratorLocation: Richmond, VA 23219 (Need to come to office 3 days a week) Duration: Full Time Permanent Salary: $DOE/Annum + Benefits NOTE: H1B Transfer acceptable and Client will file visa in premium once confirmed. NOTE: SQL DBA Architect with hands on development experience and H1B Transfer acceptable and Client will...

  • PL/SQL Developer

    3 days ago


    Richmond, United States eTek IT Services, Inc. Full time

    PL/SQL DeveloperVA/hybrid C2H Role 7+ years of hands-on PL/SQL experience, and proven understanding of Relational Databases (Oracle Exadata 12c)5+ years hands-on experience in Python/Java, including the ability to code in more than one programming language. Experience with OBIEE Report Development and Support Proven problem-solving abilities 


  • Richmond, United States TeacherOn.com Part time

    HI, I need help in creating simple tables at sql workbench and connecting the database to the websiteLevel: Bachelors/Undergraduate Gender Preference: NoneMeeting options: Available online - via skype etc.


  • Richmond, Virginia, United States TeacherOn Full time

    HI, I need help in creating simple tables at sql workbench and connecting the database to the websiteLevel: Bachelors/UndergraduateGender Preference: NoneMeeting options:Available online - via skype etc.


  • Richmond, United States NovaLink Solutions Full time

    RequirementsExperience working with Oracle PL/SQL and SQL Server Database Developement.Written and oral communicationsBackground in data integration between business systemsWrite and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production, and improved transaction editingRequirements analysis and data...


  • Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 19 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...


  • Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 17 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...


  • Richmond, United States Quest IT Solutions Inc Full time

    Role : Sr Oracle Database DeveloperLocation : Richmond, VADuration: 12+ MonthsNote:local to Richmond, VA Candidates preferredCandidates must attend In-person interview IF requested.QUALIFICATIONS:Experienced PL/SQL developer with skills in Oracle codingMust also have ability to do data analysis, develop requirements and data models.Must have background in...


  • Richmond, United States Quest IT Solutions Inc Full time

    Role : Sr Oracle Database DeveloperLocation : Richmond, VADuration: 12+ MonthsNote:local to Richmond, VA Candidates preferredCandidates must attend In-person interview IF requested.QUALIFICATIONS:Experienced PL/SQL developer with skills in Oracle codingMust also have ability to do data analysis, develop requirements and data models.Must have background in...