eServices Application Engineer
Location: Waltham, MA
The eServices Application Engineer (AE) works with our clients and members of the ClickSquared Account Management team to design and implement email marketing and analytics solutions for each client's unique marketing objectives and functional requirements. Design responsibilities include writing formal engineering specifications and developing time estimates for projects. Implementations leverage the ClickSquared platform, SQL Server 2005, SQL, Stored Procedures, HTML, JavaScript, and XML interfaces. Other Responsibilities include working closely with the Development Team to design, QA and implement new features to the Email platform.
The AE will design, develop, implement and maintain database solutions using SQL server (custom extensions to application functionality, creating tables, performance tuning, writing stored procedures) for the ClickSquared multi-channel marketing solution. Qualified candidates must have an in-depth understanding of relational database techniques to quickly gain understanding of complex databases and provide optimization and performance tuning for all database designs. They will need to troubleshoot and provide technical solutions to database issues encountered by new and existing applications in the environment. Design, implementation and customization of new and existing database reports is also required. This candidate will actively monitor the database environment to increase efficiency, and improve reliability and must have the ability to envision optimal system development and migration approach. This role will also be involved in identifying, diagnosing and suggesting resolutions to issues related to web server and web application production issues as they occur. This individual needs to implement and maintain database security (setting appropriate permissions for database users, server users, Active Directory users, scanning log files,).
:: Essential Duties & Responsibilities:
- Manage email systems hardware and software to meet clients delivery objectives
- Design and implement solutions to monitor the status of mail delivery systems
- Externally troubleshoot the mail delivery process between ClickSquared and major ISPs
- Internally troubleshoot the mail delivery process by gathering data from application servers
- Communicate descriptions of mail delivery problems and proof-of-delivery information to clients IT administrators and ISP representatives
- Maintain multiple application servers through centralized administration and automation of tasks
- Responsible for scope, design, and implementation of all assigned project work
- Provide technical leadership on assigned account teams
- Collaborate with client to customize ClickSquared's email marketing and analytics application according to their unique marketing objectives and functional requirements by developing workarounds, custom user interface reports
- Responsible for supporting an Application based on advanced web architecture: Windows Server 2003, Java, JSP, Servlets, MS SQL Server platforms, XML, web services, application server, Tomcat server, using IE browser and stand alone applications.
- Analyze and manipulate SQL databases in order to troubleshoot and resolve technical issues
- Responsible for using SQL knowledge to manage MS SQL Server based environment using Microsoft Management Console tools like SQL Server Enterprise Manager and the SQL Server Query Analyzer.
- SQL Responsibilities include creation of stored procedures, migration/transformation of data from multiple environments, develop, organize, and implement complex business rules for data sharing between systems. Enhancing the database performance with table indexing and SQL tuning.
- Provide customer training and support on advanced features of the application.
- Documentation creation including internal/external technical requirements, design documents and help doc.
- Participate in the pre and post planned upgrades and bug fix rollouts. Work with IT and development team on day to day basis on maintenance, migration and back-up of MS SQL data
:: Education, Knowledge & Experience:
- 3-5 years experience developing and implementing business solutions in a fast-paced environment
- 2-4 years experience designing and maintaining SQL databases
- In-depth knowledge of database systems architectures and optimization techniques
- Provide database support in troubleshooting basic database application and computing problems
- 2-4 years experience using HTML, XML, JavaScript
- 1-3 years designing and implementing solutions to automate tasks using Java, VBScript, or similar methods
- Knowledge of email authentication methodologies (SenderID, SPF, DomainKeys) a plus
- Experience running projects that are on time and under budget
- BA/BS required, Computer Science or related degree preferred
:: Required Skills:
- Exceptional Knowledge of SQL and underlying design theory in RDBMS
- Demonstrates creative and effective troubleshooting methodologies
- Proficient in HTML, XSL and XML, JavaScript, and CSS style sheets
- Ability to work with clients to define deliverables and develop value-adding solutions
- Knowledge of TCP/IP networking and all of the following protocols: DNS, SMTP, HTTP
- Understanding of large-scale use of SMTP protocol and its implications (throttles, timeouts, retries, bounces, etc.)
- Experience working with ISPs a plus
- Communicate technical information to non-technical personnel effectively, both orally and in writing
- Skilled in designing low-maintenance solutions that endure in the long term
- Knowledge of database marketing and Customer Relationship Management tools
:: About ClickSquared:
ClickSquared is the premier real time relationship marketing services provider of intelligent, multi-channel marketing solutions creating perfectly timed, personalized interactions across all online and off-line direct channels. Leveraging a team of marketing and technology experts and an on-demand marketing platform, ClickSquared develops and executes accountable acquisition, growth and loyalty programs to help build some of the worlds best known brands. For more information on ClickSquared visit the companys web site at www.clicksquared.com. www.clicksquared.com.
