SQL Database Administrator needed in Boston, MA.
Trillium Technical is currently seeking a SQL Database Administrator who shall work closely with the DPH IT Leadership and will be responsible for the proper maintenance, documentation, support, and enhancements to the current application environments. Strong verbal, analytical, and written communication skills are required.
Candidate will be responsible for gathering, analyzing, documenting and maintaining all data requirements related to the business applications, interfaces, and reporting environments. This documentation shall include all logical and physical data models, all required Gap analysis, all source to target specifications & all business logic or rules required to translate the business functional and technical requirements.
The Analyst shall be assigned to daily operations, as well as to ongoing projects, with a focus of .meeting the business objectives of quality, on time, and on budget goals, shall expertly utilize standard Oracle & SQL Server tools and possibly other third party and data modeling tools to develop and implementing highly efficient, scalable, and automated ETL processes.
Candidate will be required to develop technical specifications and detailed work plans, ensuring both system and data quality. Data quality management efforts may include: data cleansing, deduplication, error reporting and debugging using the standard ETL tool set. The Analyst shall provide consultation services to clients, technicians and possible other departments.
Candidate is responsible for ensuring high availability of all related business applications through the strict adherence to all PMO processes, ensuring proper Confidentiality of data, Security, Quality Assurance, Change Management, and Release Management practices.
This position reports directly to Applications Manager and the Bureaus designated IT Program Manager.
Research, analyze, document, and maintain internal Applications and Database architectures
Assist with RICE (Reports, Integrations, Conversions, and Enhancements) through the use of current tools.
Develop work plans, schedules, and manage to target deadlines on short term and long-term initiatives
Provide technical assistance and information to technical and non-technical users
Responsible for running monthly reports, managing data extracts/imports and provide data quality verification
Continually look for opportunities to improve and automate current processes.
Ensure adherence and compliance to department policies, guidelines and objectives,
Collaborate across multiple teams including research, architecture, design, development and support teams.
Analyze, design, implement and maintain the businesses critical-systems, maintaining at all times the proper data security standards set forth by the organization.
Provide tier-3 support; which may include problem definition, solution design, business continuity, backup and restore requirements resolve complex system” issues and incidents escalated from lower support tiers.
Provide SQL development and coding (PL\SQL,TSQL) for internal projects and teach/mentor other team members.
If you are interested, apply now.
Strong knowledge of Database server administration and in virtual environments.
Strong knowledge of how Indexes, index management, Integrity cheeks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. Knowledge of Database native tools ( Profiler, DTA, SSMS, SAC, SSCM, PeriMon, DMVs, system sprocs) Working knowledge of other advanced ETL tools are preferred but not required (Informatica, Pentaho Data Integrator, DataStage, Creole Data Integrator/Data Warehouse Builder, CloverETL, Talend etc.), Working knowledge Database Error and Exception Handling.
Knowledge of J2EE/Web/Application server and troubleshooting application/server logs.
4-8 years of experience developing PL/SQL code and install/implement production environments.
5+ years of experience in database administration, SQL tuning, expdp/impdp, SQL loader, Erwin/Data modeler, OEM and ADDM/AWR. generation.
3+ years of experience in database parameter tuning, data guard and golden gate.
Trillium has been recruiting and placing professionals for over 30 years. From Fortune 100 companies to small businesses, our philosophy remains the same: to achieve excellence by providing quality employees and an uncompromising level of service. We believe in honesty, integrity, and a simple philosophy of providing value to our customers and our employees. We strive to be unsurpassed in the recruitment and placement of quality and skilled professionals. Trillium is an Equal Opportunity Employer.
Contact Us if you have any questions
One moment please while we grab your information.