Senior Software Engineer
Job Description
Job Location: Mechanicsville, VA
Job Duration: Full time
Hours: 9:00am to 5:00pm Weekdays (Monday – Friday)
Minimum Degree Requirement: Bachelor’s degree or equivalent in computer Science, Information Technology,
Electronic Engineering or related field.
Minimum work Experience: 3 Years of Experience
Key Responsibilities
- Design scalable relational data models for both small and enterprise-grade applications.
- Develop, test, debug, and document complex database programs to ensure production data processing meets business and user requirements.
- Build and support system interfaces, collaborating with project managers to define specifications for core application modules.
- Partner with developers, project managers, and analysts to design new applications and document processes for effective evaluation and maintenance.
- Analyze technical design documents and ensure smooth transitions by developing SQL packages that support application development teams.
- Perform SQL and PL/SQL tuning and optimization for new and existing applications.
- Conduct data profiling and data mapping to maintain high data quality within Azure Data Lake Storage.
- Identify, assess, and support organizational data sources to enable Azure-based data integrations.
- Monitor, maintain, and enhance PL/SQL packages, stored procedures, and relational database structures as needed.
- Evaluate Oracle application architectures, design logical data models, and maintain database objects across application components.
- Implement Azure DevOps (VSTS/TFS) branching and merging strategies to support development and deployment workflows.
- Collaborate with Microsoft Dataverse and Power BI teams to fulfill client reporting and analytics requirements.
- Work closely with Solution Architects and Enterprise Architects to align technical solutions with enterprise standards and translate requirements into secure, scalable designs.
- Troubleshoot and resolve complex production issues across data and application environments.
- Perform data analysis and validation to support business and technical stakeholders.
- Identify and address performance issues across production and test systems.
- Collaborate with teams operating within Agile, DevOps, and TFS-based delivery models.
Technical Experience
- 2 years of hands‑on experience in SQL development, database programming, or data engineering.
- 1 year of experience with relational database design and foundational data modeling.
- 3 years of experience writing SQL queries, stored procedures, functions, and basic PL/SQL or T‑SQL scripts.
- 1 year of exposure to performance tuning, query optimization, or troubleshooting database issues.
- 2 years of experience performing data profiling, data mapping, or data quality validation.
- 1 year of experience working with cloud data platforms such as Azure SQL, Azure Data Lake, or Azure Data Factory.
- 2 years of experience supporting ETL/ELT processes or data integrations across multiple sources.
- 3 years of experience using version control tools such as Azure DevOps, Git, or TFS.
- 1 year of experience documenting technical processes, data flows, or system interfaces.
- 3 years of experience analyzing data and troubleshooting issues in development, test, or production environments.
- 2 years of experience identifying and resolving performance issues in database or application systems.
- 1 year of experience collaborating within Agile, DevOps, or TFS‑based development teams.
- 2 years of experience communicating with cross‑functional teams including developers, analysts, and project managers.