Senior Developer (SQL focus) Job at ClearPoint Strategy
The Senior Software Developer, Product Development is responsible for maintaining and expanding the code base. This role, which reports to the Manager, is tasked with developing interfaces and services, while working with other software developers. At this level, the developer takes ownership of several parts of the application, including the SQL database and AWS.
This includes monitoring and maintenance of these systems. To be successful, the developer must work with the Product Management team to collaboratively develop and execute feature development in an Agile software development process. A critical part of the job includes participating in a work environment where collaboration and professional development are key drivers of success.
Responsibilities
- Monitor, maintain and optimize the performance of the SQL database.
- Administer AWS and related services for deployment and systems monitoring.
- Develop new features and fix existing issues.
- Build out tests and ensure test coverage across the application.
- Review code and provides actionable recommendations for improvement.
- Coach and mentor junior developers to increase their proficiency.
- Diagnose and communicate problem areas across the application.
- Optimize performance of existing user interfaces and services.
- Take ownership of several parts of the application, documenting them and supporting other developers that work on them (SQL and AWS).
- Proactively views articles, tutorials, and videos to learn about new technologies and shares knowledge with the team and encourages team learning.
- Other duties as assigned.
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Key Result Areas
- Optimize performance of SQL database.
- Continually improve the application database and use of AWS.
- Maintain stability, low error rates and quick response times.
- Maintain and improve testing of the database before deploying changes.
- Deliver improvements on time according to roadmap and sprint goals
- Readable and well documented code and procedures
Required Experience
- 3+ years of experience in SQL database development and a strong technical background
- Proven expertise in T-SQL stored procedures, functions, and index optimization
- 3+ years of experience working with cloud-based services, like AWS
- Understanding best practices based on Agile principles
- Understanding of version control systems (e.g. git)
Preferred Education and Experience
- Bachelor's degree in a technology or engineering science degree at an accredited institution
- Experience with C# and CLR
- Experience working with javascript, front-end and back-end technologies
- Background in strategy and performance management
Job-Specific Competencies
Development
- Builds frameworks and procedures that others in the organization use.
- Designs systems that integrate well with the application, along with support for monitoring, reporting, fail over, etc.
- Produces solutions that encapsulate aspects of issues that are subject to change
- Code and configuration is well commented with sources, uses, and where it fits into the larger application
- Thoroughly and exhaustively tests database and systems. Able to set up automated functional and load/performance tests. Understands the cost / benefit of testing.
- Maintain a consistent exception handling strategy system wide. Creates guidelines for exception handling across the system
- Actively works and contributes to the underlying API. Can determine whether a problem is best solved at the client or the server.
- Implements large features into the codebase and easily conceptualizes the changes required for most features or bug fixes
- Domain expert. Has designed and implemented several products/solutions in the domain. Well versed with strategy execution personas and use cases.
- Able to offer better alternatives and flows to given requirements based on experience
- Sets up scripts to build containers and also documentation, installers, generate release notes and tag the code in source control.
- Has written and published reusable code to improve the productivity of others in the organization.
- Can do basic database administration, performance optimization, index optimization, write advanced select queries, understand how data / indices are stored internally etc.
Development Team Collaborator
- Develops and maintains processes to minimize bugs and complete features quickly
- Actively provides help and support to other developers, seeks guidance from management as needed
- Provides good estimates of work timeframes and actively suggests best allotment of time
- Breaks down tasks to drive feature completion across the development team
- Mentors developers on best practices and skill-building
- Suggests resources for professional development to other developers based on their needs
- Develops and provides a framework for supporting changes to how services are integrated
- Maintains easy-to-read documentation on new and existing features
Work Environment
- Remote position based in Atlanta, GA with main office in Arlington, VA.
- Work hours are Eastern Standard Time
Why Work For ClearPoint?
- The chance to get in on the “ground floor” of a tech company with startup energy
- The ability to make a difference from day one
- Fantastic colleagues and customers
- A structured mentorship program with budget and resources for career development
- A competitive salary, bonus program, and benefits, commensurate with your experience
- Fully paid health, dental, and life insurance
- 401(k) program
- Company organized volunteer days
- Employee referral bonuses to encourage the addition of great new people to the team
- Team events and offsite retreats
- Open vacation policy
Interested?
Please read this posting carefully, visit our website, learn about us, and then apply. To be considered, please fill out the form and attach your resume. We needed someone yesterday, and we are excited to grow our team, so if you're a good fit, expect this process to move quickly.
Pre-Employment Background Checks
All offers of employment are contingent upon clear results of a thorough background check. Background checks will be conducted on all final candidates and on all employees who are promoted, as deemed necessary and may include: Social Security Verification, Criminal History, Credit History, Personal and Professional References, social media, Prior Employment Verification, Educational Verification, and Motor Vehicle Records. ClearPoint reserves the right to modify this policy at any time without notice.
EEO Statement
ClearPoint Strategy provides equal employment opportunities (EEO) to all employees and applicants without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, age, disability, or genetics. We seek to build a diverse staff representative of the communities we serve. All qualified applicants are strongly encouraged to apply.
Physical Requirements
This is sedentary work requiring typing and other and repetitive motions. Vocal communication is required for expressing or exchanging ideas by means of the spoken word. Hearing is required to perceive information at normal spoken word levels. Visual acuity is required for operation of a computer and for observing general surroundings and activities. The worker is not subject to adverse environmental conditions.
jSHnBjHCxN
Please Note :
clarksonsquarenyc.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, clarksonsquarenyc.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.