We provide IT Staff Augmentation Services!

Cassandra/sql Server Administrator Resume

3.00/5 (Submit Your Rating)

Pleasanton, CA

SUMMARY

  • 7+ years of experience in Cassandra, SqlServer, Linux Database Administration and experienced in Installing, Patching and Upgrading, Configuring and monitoring Production and Preproduction Servers.
  • Excellent team player as well as self - motivated that can work independently with minimal supervision.
  • Can prioritize and manage multiple tasks under pressure and trail strong and innovative approach to identifying problems and finding solutions.
  • Experience with installing, configuring and monitoring Apache Cassandra cluster
  • Designing data models in Cassandra and working with Cassandra Query Language (CQL).
  • Experience in creating column Family's; bootstrapping, decommissioning, removing, replacing, and repairing nodes.
  • Experience in creating keyspaces, tables and secondary indexes in Cassandra
  • Experience in setting up the required replication factors for keyspaces.
  • Worked on Datastax enterprise version 4.7&4.8, apache Cassandra version 2.1
  • Involved in the process of data modelingCassandraSchemaand Created highly efficient data models in CQL for customer data.
  • Installed and Configured Datastax Ops Center forCassandraCluster maintenance and alerts.
  • BenchmarkedCassandracluster based on the expected traffic for the use case and optimized for low latency.
  • BuiltCassandraCluster both on the physical machines and on AWS.
  • Exported the business required information to RDBMS using Sqoop to make the data available for BI team to generate reports based on data.
  • Actively participated with the development team to meet the specific customer requirements and proposed effective Hadoop solutions
  • Implemented advanced procedures like text analytics and processing using the in-memory computing capabilities like spark.
  • Experience in performance tuning aCassandracluster to optimize it for writes and reads.
  • Performance tuning and stress-testing of NoSQL database environments in order to ensure acceptable database performance in production mode.
  • Scheduled repair and cleanup process in production environment
  • Experiences with providing authentication and security to Cassandra clusters.
  • Tested the high-availability architecture with enabling/disabling SSL.
  • Hands-on experience in Installing and configuring SQL Server 2008/2008 R2/ 2012/2014 Enterprise server’s cluster and non-cluster environment.
  • Applying service packs, patching and hot fixes cumulative updates in Development test and production environment
  • InstalledSQLServer 2014 andSQLServer 2012 with latest service pack and hot fixes and documented the same
  • Expertise in capacity planning, sizing and database growth
  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Proficiency and expertise in migrating Databases from SQL Server 2005\2008\2012under various Process like Backup\Restore; Detach\Attach, import\export etc.
  • Expertise with the role of Transaction logs and actions accordingly Log Space Maintenance and Temp database issues.
  • Experience in implementing Point in time Recovery from Production database.
  • Experience using SQL Server features like Policy Based Management, Data Compression, resource Governor, Performance Data Collector and transparent Data Encryption (TDE).
  • Experience in managing database audit events and audit records and in creating, monitoring Maintenance plans/SQL Jobs, Job Scheduling.
  • Implementing and Monitoring HADR solutions like mirroring, log shipping, replication, clustering and Always On.
  • Hands on experience in setting up Database Mirroring in High Performance and High Availability mode and troubleshoot issues with the same.
  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Expertise and proficiency in MS SQL Server performance tuning, query optimization, client server connectivity and database consistency checks using DBCC.
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer
  • Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, IDERA Diagnostic Manager, and Index Tuning Wizard.
  • Experience in Performance Tuning like Identify long running queries, Open transactions, blockings, Dead locks, Trace Flags etc.
  • Installation, configuration and upgrade of Red Hat Enterprise Linux 5/6 and centos 6/7 operating systems.
  • Installed Cent OS using Pre-Execution environment boot and Kick start method on multiple servers.
  • Installing and configuring Windows Active directory server 2000 and Citrix Servers.
  • Responsible for upgrades to Red Hat Linux with Software packages, patches and maintained them in accordance with established policies, procedures and service level agreements.
  • Creating System Disk Partition, mirroring root disk drive, configuring device groups in UNIX and Linux environment.
  • Managed physical and Logical volumes, Volume Groups using Logical Volume Manager and created/ extended file systems in Linux.
  • User administration which included creating backup account for new users and deleting account for the retired or deleted users.
  • Expertise on Yum configuration and RPM package management.
  • Experience in adding and configuring devices like hard disks and backup devices etc.
  • Performance monitoring and performance tuning using top, prstat, Vmstat, PS, Iostat etc.
  • Working with DBA’s for writing Scripts to take database backup and scheduling backup using cron jobs.
  • Troubleshooting and solving problems related to users, applications, hardware etc.
  • Provided 24x7 supports on pager rotation basis.

TECHNICAL SKILLS

Operating Systems: Citrix XenServer, Windows 2008/2008R2/2012, Windows 98/XP/professional, Ubuntu, centos, red hat Linux enterprise.

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, Business Intelligence Development Studio, and SSIS

Web technologies: HTML, CSS, BOOTSTRAP, JAVASCRIPT

Languages: T-SQL, C, CQL, shell scripting

Reporting tools: SQL Server Reporting Services

Networking: TCP/IP, Named pipes

Other tools: Lite Speed, Solar Winds DPA, Red Gate Monitoring, idera diagnostic manager, Datastax devcenter, Datastax Opscenter .

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Cassandra/SQL Server Administrator

Responsibilities:

  • Extensive knowledge on database administration for SqlServer and ApacheCassandra with experience on large scale database environments.
  • In depth knowledge of ApacheCassandra and Datastax EnterpriseCassandra
  • In depth knowledge inCassandra read, writes paths and internal architecture.
  • Experience with installing, configuring and monitoring ApacheCassandra cluster.
  • Experience in implementing multi - datacenter cluster.
  • Designing data models inCassandra and working withCassandra Query Language (CQL).
  • Experience in creating column Family's; bootstrapping, decommissioning, removing, replacing, and repairing nodes.
  • Experience in creating keyspaces, tables and secondary indexes inCassandra.
  • Experience in setting up the required replication factors for keyspaces.
  • Implemented Spark solution to generate reports fromCassandra data
  • Experience in generating user specific reports based on indexed columns using SPARK
  • Experience in fetching and loading data inCassandra using Spark
  • UtilizedCassandra tools including sstableloader,sstable2json and json2sstable, COPY for application data loading and analysis
  • Experience in Performance tuning ApacheCassandra cluster to optimize writes and reads
  • Troubleshoot read/write latency and timeout issues inCassandra
  • Good knowledge on Datastax Search/ Solr in indexing and managing searches.
  • Good knowledge on Hadoop Architecture and Hadoop echo system
  • In depth knowledge on integratingCassandra with Hadoop
  • Good knowledge on Spark SQL, Spark Streaming and Scala.
  • Installed configured and maintained SQLServer2008/2008R2/2012/2014
  • Installed, configured and deployed SSIS, SSRS, and SSAS.
  • Upgraded and MigratedSQLServers from 2005/2008R2 to 2012/2014 on VM ware Fail over Clustered and Standalone environment and documented the process with Pre-Migration and Post-Migration steps.
  • Upgraded SQL server 2008 and and 2008R2.
  • Applied latest Service Packs and Hot fixes to ease migration process.
  • Experienced with Integration Services and ETL development.
  • Implemented the new SQL Server 2012 features like contained database.
  • Implemented and managed mirroring, replication, log shipped, clustering, and Always On.
  • Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration.
  • Worked in SQL Server clustered SAN of fault-tolerant RAID environment.
  • Tested and deployed new database structures, such as tables, indexes and stored procedures.
  • Developed and automated daily, weekly and monthly maintenance tasks.
  • Implemented SQL server security best practices and transparent data encryption (TDE).
  • Worked on database integrity by performing backups, consistency checks, and performance monitoring.
  • Worked on optimizing query, tuning stored procedures and performance monitoring with developers.
  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Environment: SQL Server 2014/2012/2008 , Windows Server 2008/2012, Query Analyzer, SQL Profiler, SSRS, SSIS, xen servers, centos 6.5, Datastax devcenter, Datastax opscenter.

Confidential, Bloomington, IL

SQL Server DBA

Responsibilities:

  • Installed and configured stand-alone clustered SQL Server 2005/2008, SSIS and SSRS.
  • Migrated databases from SQL Server 2005 to SQL Server 2008.
  • Worked on database modeling on MSSQL server databases.
  • Performed job scheduling, create operators and alerts using SQL Server agent service.
  • SQL Development- write and troubleshoot SQL Code and design of views, triggers, indexes, constraints.
  • Managed Backup, Restore, recovery strategy and Security of databases.
  • Implemented database security measures, specify users and user access levels for each database.
  • Troubleshoot, monitored, optimized and tuned using Database Tuning Advisor & profiler
  • Maintenance plan mainly backup, database integrity, indexing, and statistics updates.
  • Plan, Implement and test full disaster recovery at all levels of SQL Server.
  • High availability and disaster recovery solutions like mirroring, log shipping, replication, and clustering.
  • Experienced in implementing operational automation using TSQL scripts and GUI.
  • Modified existing databases and database management systems with developers to make changes.

Environment: SQL Server 2012/2008 R2, Windows Server 2008/2012, Query Analyzer, SQL Profiler, SSRS, SSIS.

Confidential

SQL Server DBA \ DEVELOPER

Responsibilities:

  • Provided 24/7 on call production supports.
  • Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a
  • Test environment to be the future production environment.
  • Worked extensively on installing, configuring and maintaining of SQL Server 2005 and 2008 on Windows server 2003.
  • Configured the Log shipping and scheduled jobs to setup log shipping between production Servers.
  • Implemented and tested the point in time recovery of the production databases.
  • Implemented Transactional Replication between Primary Server and Sub Systems.
  • Involved in development of automated daily, weekly and monthly system maintenance tasks Such as database backup, replication verification, and database integrity verification and Indexing updates.
  • Created Users and Roles, and managed security and permission of different SQL Server Objects.
  • Exported and imported data from text files and Excel to SQL Server using bulk copy insert And BCP utility.
  • Running DBCC consistency check, and fixing data corruption in user databases.
  • Experience in Tuning Databases using Performance Dashboard.
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Maintained stand by servers using log shipping and replication concepts.
  • Coordinating with the development team regarding tuning the SQL queries and stored Procedures.

Environment: SQL Server 2012/2008R2/2008, Windows Server 2008/2003, Query Analyzer, SQL Profiler, SSRS, SSIS.

Confidential

Junior Linux Administrator (DBA)

Responsibilities:

  • Experience administering, installing, configuring and maintaining Linux.
  • Experience installing, upgrading and configuring Red Hat Linux 4.x, 5.x, 6.x using Kickstart Servers and Interactive Installation.
  • Responsible for creating and managing user accounts, security, rights, disk space and process monitoring in Solaris, CentOS and Red hat Linux.
  • Configures DNS, NFS, FTP, remote access, and security management.
  • Creates Linux Virtual Machines using VMware Virtual Center.
  • Installs, upgrades and manages packages via RPM and YUM package management
  • Installs Firmware Upgrades, kernel patches, systems configuration, performance tuning on Unix/Linux systems.
  • Installs, configures and supports Apache on Linux production servers.
  • Manages Patches configuration, version control, service pack and reviews connectivity issues regarding security problem.
  • Manages systems routine backup, scheduling jobs and enabling cron jobs.
  • Managed systems routine backup, scheduling jobs, enabling cron jobs, enabling system logging and network logging of servers for maintenance.
  • Performed RPM and YUM package installations, patch and other server management.
  • Installed and configured Logical Volume Manager - LVM and RAID.
  • Documented all setup procedures and System Related Policies (SOP's).
  • Provided 24/7 technical support to Production and development environment.
  • Provides system administrative support for servers and workstations;
  • Software and hardware upgrades and routine systems maintenance by installing current Patches and Packages;
  • Utilizing SAR, Netstat, Iostat and Vmstat for performance analysis, tuning and capacity planning, problem prevention, detection and resolution;
  • Assisted senior-level administrator in various aspects of Linux(Redhat) server administration including installing and maintaining the operating system software, performance monitoring, problem analysis and resolution and production support;
  • Disk Management like adding and replacing of hot swappable drives on existing servers, partitioning per requirement, creating new file systems and growing new ones
  • Established and maintained user accounts, assigned file permissions and established password and account policies;
  • Troubleshoot and resolved basic level system hardware, software and communications problems;
  • Performed basic system monitoring, verified the integrity and availability of all hardware, server resources, systems and key processes, reviewed system and application logs, and verified completion;
  • Monitored server and application performance &tuned I/O, memory
  • Installation of SSH and configuring of keys base authentication
  • Performed backup/restore operations using tar, cpio, dd, ufsdump, ufsrestore
  • Maintaining appropriate file and system security, monitoring and controlling system access, changing permission, ownership of files and directories, maintaining passwords, assigning special privileges to selected users and controlling file access, monitoring status of process to increase system efficiency, scheduling system related cron jobs.
  • Installed and upgraded video cards, modems, hard drives, IDE controllers, SCSI drives, power supplier and memory components.
  • Performed system configuration and troubleshooting.
  • Created and managed user accounts and security.

We'd love your feedback!