Senior Database Designer/Administrator Job in Maynard 01754, Massachusetts US
TheSenior SQL Server DBA/Developer will be responsible for building and maintain a production environment of SQL Server database for company’s sales reporting and analysis.
Essential Functions:
- Administration and support of SQL Server database systems including installation, upgrades, configuration, system monitoring, performance tuning, backup, troubleshooting, and other maintenances.
- Ensure data and reporting integrity, ETL, and other integration between data sources. Manage the implementation and user security for the database
- Provide support to sales reporting and analytics team by collecting and analyzing data, reporting results, coordinating with IT department for the long term solution business requirement building, project participation and results testing
- Provide development and production support for complex SSIS packages.
- Develop custom scripts to automate various database management processes.
- Resolve blocking and deadlocking issues, high CPU / memory, analyze job timeouts, ETL loader performance problems, etc.
- Help troubleshoot performance problems.
- Enforce database standards, best practices, methodologies, processes and procedures, etc.
- Research new technologies to enhance performance, heighten security, ensure uptime, automate common / redundant administrative duties.
- Produce and maintain documentation including: Database Standards, Naming Conventions, Administrative Techniques, Troubleshooting Techniques, Processes, Rules and Regulations, Change Management, Best Practices, etc.
- Provide operational, on-call rotational support for database environments.
- Collaborate with external teams on data warehouse development.
Job Requirements:
- Bachelor's degree in computer science or equivalent work experience.
- 5-7 years of experience of administering SQL Server databases; or must have 5-7 years of professional experience with database administration and analysis
- Experience with query and reporting tools such as Hyperion/Brio, Business Objects and SQL Server
- Microsoft SQL Certification is preferred (a plus)
- Relies on experience and judgment to plan and accomplish goals. Flexible and cooperative work style with ability to reprioritize at a moment’s notice.
- Strong individual performer and team player who can thrive in a dynamic and fast paced environment,
- Project management experiences a plus
October 25, 2011
• Tags: Administrator Job in Maynard 01754, Massachusetts Us, Senior Database Designer • Posted in: General