Job Requirements
5 - 10 years of experience
This job post is managed by
HR ANOTECH
Last active 2 years ago
Skills
Job description for Senior Software Engineer (Database Developer) at ANOTECH Singapore
Toolbox
· MS Office
· Jira/TFS and its KPI dashboard
· Polarion
Software Department level
· Report openly to the Head of Software Engineering of its BL, Business Line (RCS or ICS)
· Attend to the Department meetings, workshops and trainings
· Share the best practices with the other projects
· Raise the alerts regarding technical or methods issues
· Participate in the continuous improvement of the Department
· Follow software development process as defined in Chorus II DDQS process
Projects/Bids/Platforms level
· Report openly to the Software Work Package Manager
· Feedback and support Software Work Package Manager in decision
· Provide Software Work Package Manager with relative task estimate and variance if any
· Focus on the task in high priority set by Software Work Package Manager
· Lead its own Software activities on time and quality requirements as per Software Development Plan (SDP)
· Allocate and trace software solution requirements to system requirements
· Maintain traceability of software solution requirements against system requirements
· Design the software solution architecture and interfaces to meet functional and performances requirements
· Software documentation writing, such as: Software Requirement Specifications (SRS), Software Design
· Documentation (SDS) and Detail Interface Specification (DIS)
· People level
· Problem solver attitude i.e. raise blocking issues and contribute to solution
· Open and continuous feedback
· Self-Leadership
· Team spirit
Key Competencies
· Transparent, you share all relevant information to make decisions including your thoughts, feelings, and strategies
· Innovative, you are genuinely interested in others’ views and seek them out so that you and others can learn
· Self-Leadership, you take ownership of your contribution to get things done and seek for continuous improvement
· Accountable, you take responsibility for your actions and their short- and long-term consequences
· Profitable, you act in ways that maximize company’s interest and profitability
Requirements
Academic and working experience
· Msc Computer Science or equivalent, or
· BEng Computer Engineering or equivalent with 3 years of working experience in Software (near real time embedded and/or system of systems environment), or
· At least 7 years working experience in Software (near real time embedded and/or system of systems environment)
Technologies
· Fluent in at least 5 “compiled” programming language: C, C++, C#
· Fluent in at least 5 “interpreted” programming language: Java, Tcl, JavaScript (Angular.js), Ruby, Python
· At least 3 years working experience in relational Data Base: SQL, SQL server, MySQL, PostgreSQL , Oracle
· At least 3 years working experience in Data model language: XML, JSON, XDR, HTML (CSS)
· At least 5 years working experience with MS Visual Studio IDE and .Net framework
· At least 2 years working experience in network programming (TCP/IP, client-server, network socket)
· At least 5 years working experience in at least 2 of these (RT)OS architectures: Win XP/7, WinCE, Windows
Embedded
· At least 1 year working experience in REST and SOAP web services
· Capacity to structure, estimate, plan and self-lead his/her activities
· Capacity to summarize and send appropriate reporting
· MS Office pack experience
· Fluent in English and capacity to write technical documentation in English
· Experience in the following area would be appreciated:
o Agile Development Process (i.e. SCRUM)
o Continuous Integration and tools (Jenkins, Sonar)
o Object-Relational Mapping library (Hibernate)
o Web and app servers (Tomcat, Jetty, Node.js)
o Android and Linux architecture
o Advanced Message Queuing Protocol (RabbitMQ, WebSphereMQ)
o SPRING framework
o Virtualization tools (VMWare, Docker)
o Build automation tools (CMake, Maven, Ant)
o IT automation tools (Puppet, Ansible)
o Test driven design frameworks (JUnit, RobotFramework, FitNesse)
o Test automation tools (JMeter, JBehave)
Specific for Information Database Design and Development
At least 5 years of solid experience in the following areas:
· SQL:
o Generate on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
o Scheduled and Delivered on-demand reports for business analysis using SQL Server Reporting Services.
o Handled data modelling tasks using SQL Developer Data Modeller to enhance productivity.
o Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
o Designed and deployed reports in MS SQL Server environment using SSRS and created Sub-Reports, Drilldown-Reports for the clients.
o Created, tested, performance tuned and implemented stored procedures and queries in Microsoft SQL Server.
o Collaborated with team members in writing test SQL scripts, performing tests and providing appropriate follow-up actions and documentation.
· SSIS:
o Implemented package configurations using parameters in SSIS to make packages dynamic.
o Developed SSIS package to bring the data from Excel, Flat file and Oracle using Business Intelligence (BI) tool.
o Created complex ETL (SSIS) packages to pull data from Oracle, load monthly data from Excel to SQL server.
o Created multiple SSIS packages to clean the incoming data including address and to find the data information is valid or not.
o Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
o Created SSIS packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
o Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
o Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server.
· Data Warehouse:
o Involved in designing Technical specification document, identified various data mappings and the design of Data warehouse.
o Involved in designing the data warehouse on business requirement and provided relevant documentation.
o Involved in designing multidimensional OLAP cubes in SSAS from the existing data warehouse.
o Used SQL Server Integration Services to design and build the ETL procedures and a Data Warehouse to meet client requirements.
o Designed and developed SSIS packages for Historical Load and Incremental Load (Daily Updates) to feed the data warehouse.
o Designed packages and data mappings to load data from different data sources to destinations in data warehouse by SSIS.
· Database:
o Used different Data Definition and Data Manipulation languages, implemented constraints and triggers for data integrity on the relational database tables.
o Developed/modified Stored Procedures, Views for different reports and performed optimization techniques for these database objects to improve the performance.
o Coordinated and performed quality assurance testing for movement of database and objects from development environment to testing and production environments.
o Design logical and physical database, develop, normalizing data modeling using SQL Server Enterprise Management Studio.
· Web Portal:
o Design and develop web portal for accessing reports hosts in SQL Reporting Services