| Hybrid Senior Database Administrator:: Boston, MA at Boston, Massachusetts, USA |
| Email: [email protected] |
| From: Abhishek kumar singh, Tek Inspirations [email protected] Reply to: [email protected] Role: Senior Database Administrator Location: Hybrid (Boston, MA) Visa: GC/USC Only MOI: Skype Duration: 6 months MUST BE WILLING TO COMMUTE OR RELOCATE TO BOSTON Location/Remote: Boston, MA 02215 they want someone in New England onsite 2 times a week for the first month to get acclimated but then they can chose to keep doing that or go onsite 2 times a month. **They arent set up in CT for payroll but they will consider it for the right candidate and can get it set up while they contract. 5+ years of SQL Server DBA experience with at least 2 in a Senior/Lead role, SQL 2012 or newer, SSIS, T-SQL and PowerShel They use Snowflake and Azure so exposure to at least one of those or AWS. Understanding of data engineering fundamentals Education, Experience, & Skills: Bachelors degree in Information Technology, Computer Science, or related field (Masters degree preferred). 5-8+ years of proven experience as a MS SQL Server Database Administrator with at least 2 years in a senior or lead capacity. In-depth knowledge of Microsoft SQL Server versions 2012+ and associated tools (SSMS, SQL Server Profiler, Performance Tuning Advisor, Best Practices Analyzer, etc.). Hands-on experience building, maintaining, and administering SSIS ETL packages and its runtime environment on SQL Server. Highly skilled and proficient in T-SQL. Hands-on experience with PowerShell and automation is highly preferred. Sound knowledge of relational database design and modeling fundamentals, principles, and best-practices. Hands-on knowledge of cloud-based database services such as Snowflake, AWS/Azure RDS or similar, is highly preferred. Experience in implementing and managing High Availability and Disaster Recovery solutions (Always-On Availability Groups, Log Shipping, etc.). Strong knowledge and experience with server hardware including OS, storage and related technologies. Proficient in database security best practices and regulatory compliance requirements (data de-identification, encryption, masking etc.) Experience in setting up and managing Snowflake security, including role-based access controls, encryption, and data masking is a plus. Knowledge in non-relational database technologies such as Azure NoSQL, MongoDB etc., is a plus. Proficiency in Confluence and Jira is preferred. Excellent problem-solving and analytical skills, with the ability to troubleshoot complex database issues effectively. Excellent planning skills with the ability to identify potential risks and tradeoffs. Exceptional communication and interpersonal skills to effectively collaborate with team members and stakeholders. Ability to be flexible, meet deadlines, multi-task between projects and prioritize work based on urgency, criticality, and business need. Relevant certifications in database administration would be a plus. Key Duties & Accountabilities Oversee the installation, configuration, and maintenance of Microsoft SQL Server databases across different environments (development, test/staging, production). Administer and manage the Snowflake cloud data platform, including database objects (databases, schemas, tables, views, etc.) and user access permissions. Proactively monitor and optimize database performance by identifying and resolving bottlenecks, optimizing queries, indexes, and fine-tuning system configurations to ensure optimal database performance. Set up and maintain monitoring and alerting systems to proactively identify and address database issues related to performance, usage, and security in a timely manner. Be the subject matter expert and technical owner of the enterprise job scheduling function, related tooling, and enterprise SQL Server based ETL processes. Establish and manage robust disaster recovery and high availability strategies to minimize downtime and ensure business continuity. Plan and execute database upgrades and migrations to newer versions or hardware to keep the environment up-to-date and optimized. Conduct capacity planning assessments to predict future database resource requirements and ensure scalability. Investigate and resolve database-related incidents, working closely with development teams and other stakeholders to identify root causes and prevent recurrence to ensure smooth operations. Maintain accurate and comprehensive documentation of database configurations, processes, and procedures. Collaborate with cross-functional teams to provide technical expertise, support projects, and guide software and data engineers on best practices for database utilization. Mentor junior members of the DBA team. Provide production support as needed and be available as an on-call support personnel, off-hours and weekends at times. Performs work with near-zero supervision/guidance and can articulate rationale for decisions and changes. Thanks & Regards .. Abhishek Singh Technical Recruiter [email protected] https://www.linkedin.com/in/abhishek-singh-4949b323b/ Keywords: information technology golang green card microsoft Connecticut Delaware Massachusetts |
| [email protected] View all |
| Thu Oct 05 23:47:00 UTC 2023 |