Cigars International · 3 hours ago
Sr. Database Administrator
Bethlehem, PA
Full-time
Onsite
Senior Level
5+ years expCigars International is a world-class brand that offers a collaborative working environment. The Senior Database Administrator (DBA) will manage SQL clusters, develop best practices for database deployment, and ensure the operational integrity of databases.
Tobacco
Responsibilities
Provision and configure SQL Server instances for both new and existing products
Ensure performance, security, and availability of databases
Implement world-class database monitoring and alerting to ensure DBA is proactive in monitoring active events and proactive in preventing events such as low drive space, fragmented indexes, etc
Plan, implement, and maintain replication strategies
In depth analysis of performance, identification of areas of improvement, and implementation planning
Prepare documentation, procedures, and specifications
Handle common database procedures such as upgrade, backup, recovery, migration, etc
Profile server resource usage, optimize and tweak as necessary.24x7 Support of Production DB’s
Solid working knowledge performing OS/DB migrations on prem and in azure environments/Installation, configuration, and support of SQL Server Integration Services, Reporting Services
Support and maintenance of BI reporting platform
Participate in the creation, revision, and execution of project plans, including identifying resource needs, performing quality review, and escalating functional, technical, and organizational issues where appropriate
Windows Server Administration/Scripting – PowerShell, Python, and shell scripting are all good
Perform other duties and assist with projects as assigned
Qualification
Required
Experience serving as DBA lead
Experience in T-SQL and other developer tools used to support programming that include new functionality, automated interfaces, and/or enhancements to vendor-provided software
Knowledge of de-facto standards and best practices in SQL Server
Strong proficiency in SQL Server database management and administration including with large scale SQL Server databases
Hands-on experience implementing and maintaining Always-On Availability Groups is required. Knowledge of additional replication models is a plus
Experience working with SQL Server Integration Services (SSIS) and ETL jobs
Proficient in writing and optimizing SQL/T-SQL queries and jobs
Experience with backup and recovery strategies
Certified SQL Server DBA is a plus
Bachelor's degree in an Information Technology-related field or related work experience
5 years of related database administration and application infrastructure experience
Ability to work effectively with both technical and non-technical staff, including coordinating and planning of work efforts
Must have excellent organizational, planning, and technical skills to diagnose problems in an environment with constantly changing priorities
Excellent verbal and written communication skills
Strong analytical and quantitative skills
Ability to document associated programs and integrations
Team leadership and collaboration skills
Ability to work on small-to-complex projects that require skills in multiple technical environments
Ability to handle multiple projects/tasks simultaneously
Knowledge of project management disciplines/methodologies and change management
Excellent time management skills
Knowledge of related security best practices
Preferred
Master's degree
Project Management Institute (PMI) Project Management Professional (PMP) or related experience
SolarWinds DPA or similar monitoring solution
Benefits
Comprehensive Health Care, Vision & Dental Plan
Flexible Spending Account
Disability Plans
Basic & Supplemental Life Insurance
Additional Supplemental Benefits
Paid Vacation, Paid Time Off (PTO) days, Holidays
401(k) Retirement Saving Plan including a generous Company match
Company
Cigars International
Cigars International is an online- and catalogue based retailer of cigars owned by Scandinavian Tobacco Group A/S.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
unknown2007-08-16Acquired
Company data provided by crunchbase