What are the responsibilities and job description for the Database Engineer position at AMSC?
Summary - Job Responsibilities – Activities:
- Develop, debug, and support production database systems including stored procedures, triggers, schema design, and performance tuning.
- Design, develop, and debug production web sites and web services under the direction of management and requirements from customer groups.
- Responsible for the day-to-day data file processing of the production database.
- Archiving of data files and capacity planning of network server drive space.
- Monitor consistency of production and archive database backups.
- Lead effort to maintain browser independence and W3C standards.
- Support service personnel and customers with data queries, and web site issues.
- Maintain a proactive posture towards reusability and quality.
- Proactively define and suggest improvements to the web and database environments as well as other unrelated areas.
- Participate in investigative work pertinent to system design including feasibility studies, research, and designs of experiments to prove out project concepts.
- Stay current with new and emerging technologies and evaluate the feasibility of integration with current tools and technologies in use.
- Support of Linux platforms running production web sites, web services and databases.
- Assist in developing and maintaining software documentation.
- Produce and publish monthly metrics reports
- Other duties as assigned.
Education - Experience:
- B.S. degree in Computer Science, Electrical Engineering, Computer Engineering or a related discipline and 4-7 years in practical software engineering or M.S. degree and 2-5 years in practical software engineering.
- SQL programming
Required Skills, Competencies, Authorities and Training Needs:
- US citizenship required.
- Thorough knowledge of Relational Database Management Systems
- Experience with SQL programming language
- Experience with PostgreSQL on the Linux platform
- Familiarity with interpreted languages like Perl, Python
- Knowledge of web browser/server architecture and design techniques
- Creativity and innovation skills required to solve new problems
- Written and verbal communication skills
- Analytical skills
- Ability to work independently
- Ability to accurately estimate time required to complete software tasks and projects.
Desirable skills – technologies we use also:
- Familiarity with JSON and RESTful APIs
- Knowledge of HTML language and page design techniques
- Experience with JavaScript and the manipulation of the Document Object Model
- Knowledge of HTML5, and canvas
- Familiarity with JQuery, AJAX, D3, and React
- Familiarity with Google Maps
- Familiarity with Subversion, JIRA, Jenkins
- Prior experience with charting engines
- Prior experience with converting websites for mobile devices
- Prior experience with cloud migration (e.g. AWS)