SUMMARY:

• 12 + years of DBA, software engineering, design,development integrating solutions, analysis and programming experience.
• I applied my professional experience to develop, build,drsign,install, configure, administer, implement and manage various database related designs and resources (sql server/oracle,informix,sybase,db2,tableau,splunk and spotfire).
• I have experience designing, implementing, and maintaining relational database management systems that support enterprise - wide applications.
• I set up databases according to a company’s needs,datawarehouse,data mining, performance optimization and security, also fine-tune, upgrade and test modifications to the databases as needed before deployment in production,implement service packs.
• I resolve complex performance issues, so attention to detail is an essential trait in being a DBA and part of me, as is a passion for problem-solving.
• I have worked solving cmongoatljuase related problems in several industries ranging from oil and gas, pharmaceutiocal, healthcare,biotech,medical, insurance and life science companies

TECHNICAL SKILLS:

Programming Skills: scala,java,.Net technologies,C#,C++,apache tomkat,IIS,Python,Php,Perl,powershell,postgresql,scala,SSIS/SSAS/SSRSjsp,applet,javabeans, javascript,R,html5,css,Ajax,jquery

Statistical language: python, R

Scripting language: powershell,python,perl, javascript

Object oriented programming: java,c++, python, c#

Search engine: elastic search, apache solr

Monitoring and data analyzing tools: Nagios,Zabbix, Grafana, Jira, confluence, bitbucket, Bugzilla, gitlab,trellotableau, powerbi, alterix

Software development lifecyle: Agile,scrum,Devops

Big data proficiency & skills: Tableau, powerBI,slamdata Hadoop,spark, mapreduce

Mongodb/ couchdb/casaandra/ hbase: Hives,hdfs,Oozie,hive,kafka, impalaSqoo0,pig,Eclipse/ Angular 2/4,NodeJS,Spring MVC,Bootstrap,Apache nifi,Kafka,Storm,Spark,solar,sentry,hueMetron,Elastic search,Ibm Cognos,ibm guardiumGraphics design Adobe photoshop cc, illustrator cc, maya,3d studiomax, matlab,Autocad, Mathrmatika,css3, html5, coldfusionCloud computing proficiency: AWS/Microsoft Azure, snowflake, mongoatlas

Devops tools: Jenkins,new relics Bamboo,Docker,Kubernetes,Puppet Enterprise,Ansible. Chef, jira,grafana,Git,GitHub,nagios, Gradle

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Mongodb and Cassandra Database Administrstor

Responsibilities:

• Experience in performing Mongo DBA operational routines,performance optimization,job schedulingsharded cluster setupDatabase shrded cluster and replica set setup, configure kingod instances
• Setup Cassandra database on multiple setbers
• Design, develop and manage data on cassandra cluster
• End to end performance tuning of Cassandra clusters.
• Software patches and upgrades
• Migration from RDBMS(Sal server,Oracle and DB2)
• Capacity planning
• Monfodb and Cassandra connectivity and security in AWS and Microsoft Azure cloud
• Database replication setup
• User accounts and role creation setup
• Monitoring
• Design and implement internal process improvements, automating manual processes, optimizing data delivery and redesigning infrastructure for greater scalability. implemented successful enterprise BI solutions
• Used the Azure BI Stack and Data Integration (Data Factory, SQL Data warehouse and Azure Data Lake Storage) to peeform ETL process from various datasources
• Power BI andTableau reports development, Dashboards and Datasets to generate Advanced Analytics on structured, semi-structured and unstructured data.
• Migration of data from on premise datacenter into Amazon web services cloud and microsoft azure database cloud
• Identified ways to improve data reliability, efficiency and quality
• Powershell scripting and automation of jobs and routines.
• MMS configuration experience, Configuring and monitoring replica setsOptimizing database/query performanceConfiguring Sharding, monitoring, and identify the proper shard key
• Performing Security measures, backups and restore backups
• Working knowledge of monhodb and cassandra
• User Management - creating users, assigning roles, managing permissions

Confidential, Houston, TX

Sr Database Administrator/security administrator

Responsibilities:

• Expertise in MongoDB and cassandra. used the Azure BI Stack and Data Integration (Data Factory, SQL Data warehouse and Azure Data Lake Storage) to peeform ETL process from various datasources
• Power BI andTableau reports development, Dashboards and Datasets to generate Advanced Analytics on structured, semi - structured and unstructured data.
• Migration of data from on premise datacenter into Amazon web services cloud and microsoft azure database cloud
• Powershell scripting and automation of jobs and routines.
• SSIS,SSRS,SSAS and data warehousing, tableau report, powerBI and cognos for reporting and analysis after the ETL processis compled
• Mining of data for prexictive b ehabiour
• Performed MongoDb and cassandra DBA operational routines;
• Powershell and python scripting for automation
• Configured and monitored replica setsOptimized database query performance
• Performed backups and restore
• User Management- creating users, assigning roles, managing permissions
• Worked on IBM guardium for database security
• IBM Guardium activity monitoring and vulnerability scanning and assessmet
• Database masking and vulnerability assessment
• Experience with great understanding of using information security tools and systems experience knowledge of process definition and documentation experience
• Knowledge and understanding of application security planning and security architecture
• Knowledge and understanding of information security risk assessment or audit
• Experience with Database authentication tools, database firewall and encryption
• Excellent verbal and written communication skills and Advanced Information Security technical skills
• Ability to manage complex issues, analyze them and develop solutions
• Experience with security frameworks and regulations i.e. PCI DSS, SOX, SOC1, GLBA, NIST, ISO 270001
• Performed database upgrades from 2008 r2 to 2-012,2014 and 2016 edition of Microsoft sql server fine tune and optimize verycomplex queries Apply patches, maintained and managed all client user account Performed disaster recovery and setup replication to remove load on the production server by pulling reports from the secondary server, Experience troubleshooting all performance related issues
• SSIS,SSRS,SSAS, tableau report and cognos for data integration,transformation and mining.
• Apache hadoop, spark, hive, jira. Nosql
• Performed query aggregation and optimization
• Cloud Platform implementation and integration of Amazon web services and Microsoft Azure and web services
• Practise of agile and scrum computing

Confidential, Houston, TX

Sr Database Administrator

Responsibilities:

• Expat knowledge of MongoDB, cassandra,microsoft sql server and oracle experience in performing Mongo DBA,sql server,cassandra operational routines;
• MMS configuration experience, Configuring and monitoring replica setsOptimizing database/query performanceConfiguring Sharding, monitoring, and identify the proper shard key
• Performing Security measures, backups and restore backups
• User Management - creating users, assigning roles, managing permissions managed server backup, storage and partitions fine tune complex queries and setup maintainance jobs on the servers roubleshoot all performance related issues Apply patches, maintained and managed all client user account maintain the existing clusters and managed Cisco firewalls and concentrators for security purpose using tableau and splunk to analyze
• Big complex data IBM data security with guardium And classification of data to vulnerability assessment To data and activity monitoring Oracle 9,10g,12c database administration, support high availability architecture including always on and VLDB. - Extensive knowledge of oracle RAC
• High availability SQL Server Clustering ( installing, configuring and administering a clustered sql server. implemented Microsoft failover clustering with high availability .it improves the availability of physical server hardware, operating system and SQL server instances.
• SSIS/SSAS,SSRS and crystal reports troubleshooting and configuration and built some new drill down and drill-through reports for the management to make some key business decisions.
• New SSIS package creation and troubleshooting of the existing packages
• Converting. Old written stored procedures and business objects into packages
• Using business intelligence development studio to develop business intelligence solutions
• Database migrations of Data from SQL 2000/2005/2008/2012/2014
• Script execution and jobs creation and scheduling.
• SSIS/SSAS,SSRS
• Data mining with SSAS
• OLAP Cube designs and MDX Queries
• Database log shipping, Database mirroring and Replication Setup for disaster recovery.
• Datawarehouse implementation and designs with SSIS
• Extraction Transformation and Loading (ETL) of data from different platforms into SQL server tables and databases for further processing and analysis.
• Worked on IBM Guardium activity monitoring and vulnerability scanning and assessment
• Worked on database vulnerability and security assesment, data masking and process definition and use various nformation security tools
• Experience with security frameworks and regulations i.e. PCI DSS, SOX, SOC1, GLBA, NIST, ISO 270001

Confidential, Houston, TX

Sr Database Administrator

Responsibilities:

• Managed up to 25,000 databases in production, development, staging, UAT and sandboxes for global pharmaceutical companies, biopharm, biotech, contract research organizations and the medical device companies.
• Extreme backup and recovery
• Replication and database mirroring setup for various clients
• User account creation, modification and deletion
• Data transformation with DTS and SSIS for Data warehouse for extraction, transformation and loading
• Bbuilding server based drilldown and drillthrough reports with SQL server reporting services and business intelligence studio
• OLAP cube designs with sql server analysis services and designing pivoted tables
• Ddatabase refreshes from production to sandboxes and development environments
• Database restores with symantech netbackup software
• Tape archive of client databases to an external environment
• Knowledge of VMware and cloud computing for database in production
• Monitoring tools:prtg, performance co pilot, nagios,icinga,abturis,,opennms,op5,relic, monitis

Confidential, Houston,Tx

Global DBA

Responsibilities:

• Monitor and maintain over 7000 Global SQL Servers in Production, QA, Test, Development and staging Environments.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with application developers from other departments
• Respond to problematic ovsd tickets assigned to me and fix any database issues promptly
• Identified and resolved SQL Server Database locks and hardware - related issues, using SQL Server Profiler and SQL Server Query Tuning & Diagramming where necessary, to resolve Performance slow-downs due to blocking and other index issues, etc.
• Locking and the appropriate Isolation level hints to minimize blocking, and identified SQL Server configurations that is out of specs. Avoid transactions that require user input to commit and long-running transactions.
• Perform data Backup/updates and exports between SQL Servers, both internal and external as required. Wrote & debugged stored Procedures & Triggers using T-SQL and take infrastructure restrictions into account, in the schema design.
• Implemented Log-Shipping as high availability solution using both Enterprise and Standard SQL Server 2000 editions.
• Automated backup and recovery processes through out the environment and Automated SQL Server error log notification process without using SQL Server agent service
• Managing SQL Server clusters and Migration process from different data sources to SQL Server and Performance tuning of Database and SQL statements.
• Building OLAP cubes for DSS system and Setting replication servers using replication methods of SQL server and Administration of SQL Servers such as creating databases, security mechanisms, Auditing, maintaining proper backups
• Iimplemented clustering solutions and setup and manage replication services, management tools with extensive experience with replication from (SYBASE to SQLServer), and (SQL2k to SQL2005) and (SQL2k5 to SQL 2k5 )
• Major events tickets-Gainsville,Florida Network Security Engineer/DBA
• Diagnose low level SQL Server bottlenecks by using SQL Profiler, interrogating internal system tables and using various other utilities.
• Design creative and supportable technical solutions to challenging problems, as needed.
• Write thorough technical change plans, as needed.
• Design end-to-end solutions with Microsoft technologies, which may include but is not limited to, load balanced servers IIS servers, Report Services, n-tier servers, SQL Server clustering, SQL Server notification services, SQL Server log shipping, Microsoft Business Intelligence Suite and Web Services.
• Deploy complex SQL Server Integration Services packages.
• Assist customers with ADO.net issues with SQL Server as the data store.
• Consult internal and external customers regarding Enterprise level SQL Server design and/or end-to-end solutions to meet proposed business needs.
• Design complex SQL Server clustering, replication and log shipping models, which may involve servers across various networks.

Confidential, Houston, Tx

DBA/ NetworkAdministrator

Responsibilities:

• Managed an active directory network consisting of 500 users of Window 2000 Pro.
• Created, configured and troubleshoot email accounts with Exchange 2000.
• Cabled, configured and setup computers, peripherals.
• Created and administered all user accounts with Windows 2000 Active Directory.
• Troubleshoot all PC and network related issues.
• Performed PC upgrades and ghosting services using Norton's.
• Installed and maintained Exchange, DHCP, WINS, and backup servers.
• Provided Level III support to mail users.
• Troubleshoot all Nortel PBX phone issues.
• Diagnosed and perform network administration, maintenance and monitoring.
• Configured and troubleshoot VLAN for the Local Area Network.
• Installed and configured RAID drives for all servers.
• Responsible for all ISDN issue for Polycom phone conferencing.
• Install and troubleshoot Citrix client connection and Cisco VPN access.

Confidential

Network and Exchange Administrator

Responsibilities:

• Installed and maintained entire network, including cabling for the office as well as preparing computer resources including servers, workstations, laptops, printers, and multimedia equipment.
• Administered a Windows NT 4.0 domain environment which includes user accounts assignment, access controls and file permissions, security and system patches, and storage backup.
• Standardized suites of desktop software products allowing greater ease in document sharing, as well as the ability to upgrade software remotely and to troubleshoot more efficiently.
• Image ConsultantDatabase Developer/IT Support
• Designed and implemented Database system to track temporary employees wages, time worked as well as client information. Consolidated a three step process into to one step saving time and increasing accuracy.
• Also built Customized reports using report designer in sql server 2000.Prepared reports on status, operation, and maintenance of system software. Within two weeks decreased the amount of time on the close process construction files from 3 days to 10 minutes. Built a database that tracks all resources (hours, materials, wages etc..) for construction projects.
• Wrote data extraction scripts and queries to support the generation of reports. Test and validate integrity of data for reporting accuracy.

Confidential

Database Administrator/Developer

Responsibilities:

• SQL Server Database Administrator/Developer for a large call center.
• Involved in data warehousing, interactive voice response and .NET programming.
• Successfully developed and implemented a T - SQL based billing system that improved the accuracy and timeliness of customer invoicing. Collaborated with accounting and billing managers. Managed data modeling and programming issues.
• Re-wrote many of the .NET 'code behind' functions for applications to utilize SQL stored procedures instead of hard coded SQL queries. This protected the company data from the danger of 'SQL injection' attacks on their web pages.
• Perform Tier 3 troubleshooting and support for complex issues.
• Provide escalated implementation support.
• Create and update technical documentation, as required and Provide technical training, as needed.
• Implement enterprise level toolsets and measures to ensure the efficient management of SQL Server instances across the enterprise.