SQL
Server DBA (Garden City, NY 11530)
- RESUMES WITHOUT FULL NAME AND CURRENT ADDRESS (CITY AND STATE A MINIMUM) WILL NOT BE REVIEWED.
- RESUMES WITH ABBREVIATED CAREER HISTORY OR ONLY PARTIAL CAREER HISTORY WILL NOT BE CONSIDERED
- RESUMES FROM OUTSIDE OF THE UNITED STATES WILL NOT BE REVIEWED
Overview:
The
SQL Server Database Administrator will be responsible for Design, Development,
Installation, Performance Tuning and Maintenance of all Databases and our
Enterprise Data Warehouse to ensure high levels of Data Availability. Will Oversee
Database Policies and Procedures to ensure the Integrity and Availability of Databases
and Related Software. This is a Golden Opportunity to expand your experience
with the Latest Tools and Technology
Responsibilities:
- Design, Build, Implement, Monitor and Maintain Database Health and Performance. Define Database Security, Physical Layout and Database Functional Capabilities.
- Maintain and Troubleshoot Database Performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
- Proactively and reactively resolve database performance and capacity issues, including managing indexes, SQL trace data, audits, and alerting
- Analyze Query Execution Plans and Advise Developers on Best Practices for Database Code
- Manage and Support Team Members for requests with Integration Services (SSIS) or Reporting Services (SSRS) and other data ETL tools.
- Automate Routine Tasks and Alert Responses using PowerShell, SQL, .Net or other tools
-
Collaborate
with Development, QA, and Business Teams as needed.
Requirements:
- Bachelor's Degree or equivalent Education and Work Experience, Advanced Degree a Plus.
- Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Strong, Current SQL Database Administration and Development along with Solid Skills in Data Analysis, Reporting and Relational Database Design of SQL Server 2008R2 to 2016. Must have current experience with: SQL Server 2008R2 through 2016; SQL Server on Virtual Environments (VMware, etc.); SQL Server Always-On with Windows Clusters.
- Current experience with T-SQL, Stored Procedures, Triggers, Multidimensional Expressions (MDX), Cubes along with extensive knowledge of Administration, High Availability, Backup and Restore of MS SQL Databases.
- Experience with Replication, DTS/SSIS, Index Management, and Statistics. Reporting experience using SSRS and Crystal Reports
- Experience in Performance Tuning and Optimization (PTO), using Native Monitoring and Troubleshooting Tools
- Experience with High Availability (HA) and Disaster Recovery (DR) Options for SQL Server
- Experience in Scripting the Implementation of Operational Automation
- Solid experience with Computer Security Procedures and Protocols
- Solid Organizational, Analytical, and Problem-Solving Skills with a Demonstrated Ability to Prioritize Tasks
- Must Have Strong Interpersonal, Communication, Analytical and Documentation Skills
This is a permanent, full time position. All
candidates MUST be local to Garden City, NY. Do not apply if you are not local,
even if you would pay your own relocation. Relocation will not be considered.
All candidates must be legally eligible to
work in the United States without sponsorship and must reside locally. Sorry,
no Visa Sponsorship or Transfers at this time. No 3rd Party Recruiters unless
you represent a local candidate with all of these qualifications
RESUMES FROM OUTSIDE OF THE US WILL NOT BE
READ
